Question to Moderators about scripts Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Question to Moderators about scripts

  1. #1
    Join Date
    Aug 2000
    Chicago IL


    I was looking to use some of these tuning scripts from I was looking at your contention script..but you havent provided any references to read the output. this is true for all scripts.

    1 select
    2 event,
    3 sum(decode(wait_Time,0,0,1)) "Prev",
    4 sum(decode(wait_Time,0,1,0)) "Curr",
    5 count(*) "Tot"
    6 from
    7 v$session_Wait
    8 group by event
    9* order by 4
    SQL> /

    EVENT Prev Curr Tot
    ---------------------------------------------------------------- --------- --------- ---------
    pmon timer 0 1 1
    smon timer 0 1 1
    SQL*Net message from client 1 1 2
    rdbms ipc message 0 4 4
    "High Salaries = Happiness = Project Success."

  2. #2
    Join Date
    Oct 2000
    Saskatoon, SK, Canada
    Those are the scripts that have been contributed by the users of this site. As a result most of them don't have the output. In the mean time those outputs are generally long. In a way its good, because, it makes the user to think better and learn than just to use them.


    Life is a journey, not a destination!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width