RE: Urgent: db file sequential read - wait
- From: John Kanagaraj <john.kanagaraj@xxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 31 Mar 2004 11:06:47 -0800
Mladen,
>> Not many realize this, but v$session_wait records and
>displays the _last_
>> *instrumented* wait event.
>
>That is not quite true. If the status is "WAITING", then the
>session is waiting now.
Yes, I partly agree :( To correct the situation, I will modify my statement
to say 'v$session_wait records and displays the _last_ *instrumented* wait
event, and the session is performing some other *uninstrumented* operation
unless the STATUS is "WAITING".' Thus, a wait event such as 'enqueue' with
a "WAITING" status indicates a session that is waiting for a resource to be
freed, but an active session with 'db file sequential read' and a status of
'WAITED SHORT TIME' and an unchanging SEQ# indicates that the process is
probably spinning on LIOs.
Cary - any comments on this? Actually, I inferred this little nugget from
reading between the lines in your book.
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)
Grace - Getting something we do NOT deserve
Mercy - NOT getting something we DO deserve
Click on 'http://www.needhim.org' for Grace and Mercy that is freely
available!
** The opinions and facts contained in this message are entirely mine and do
not reflect those of my employer or customers **
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
