And there is a bug (#2803772) in 9.2.0.3 (may exist in all 9i, not sure). The seconds_in_wait is reset to 0 when the SEQ# in v$session_wait increments. A patch is available, and the bug is fixed in 9.2.0.4.
- Kirti --- Cary Millsap <[EMAIL PROTECTED]> wrote: > Fyi, seconds_in_wait is not incremented by queries of v$session_wait. It > is incremented by LGWR approximately every three seconds. > > > Cary Millsap > Hotsos Enterprises, Ltd. > http://www.hotsos.com > > Upcoming events: > - Hotsos Clinic 101 in Sydney > - Hotsos Symposium 2004, March 7-10 Dallas > - Visit www.hotsos.com for schedule details... > > > -----Original Message----- > MacGregor, Ian A. > Sent: Monday, September 22, 2003 6:40 PM > To: Multiple recipients of list ORACLE-L > > Good catch. It was showing Waited Known Time, and the seconds_in_wait > kept increasing. I was fooled by the latter being incremented each time > v$session_event was queried. I did run a trace on it to track the > waits, but had to kill the session. I've never gotten dbms_system > session traces to work. They never return anything even on newly > rebooted machines. > > Ian MacGregor > > -----Original Message----- > Sent: Saturday, September 20, 2003 4:05 AM > To: Multiple recipients of list ORACLE-L > > > Hi! > > How do you verify that your session is still waiting on sequential read? > From v$session_event? Is the status column saying WAITING there? (if it > says WAITED%, then your CPU is doing something else already, and this > record in session wait just shows the last wait). > > Tanel. > <snip> __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
