Seconds in Wait

2002-08-30 Thread MacGregor, Ian A.
so seconds_in_wait should be the Actual Wait time in Seconds. See Oracle Performance Tuning 101 pg 32. Note, also the seq# number. I am intrigued by the jump from 8 seconds to 25 seconds for the seconds_in_wait column where the clock time only advanced six seconds. Also the jump from 69

RE: Seconds in Wait

2002-08-30 Thread Cary Millsap
--- Note that the state is WAITING so seconds_in_wait should be the Actual Wait time in Seconds. See Oracle Performance Tuning 101 pg 32. Note

RE: Seconds in Wait

2002-08-30 Thread MacGregor, Ian A.
--- Note that the state is WAITING so seconds_in_wait should be the Actual Wait time in Seconds. See Oracle Performance Tuning 101 pg 32