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 <cary.millsap_at_hotsos.com> 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: kirtikumar_deshpande_at_yahoo.com
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: ListGuru_at_fatcity.com (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).
Received on Tue Sep 23 2003 - 09:39:49 CDT
