RE: Urgent: db file sequential read - wait

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_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

  ---