RE: many seconds waiting for I/O?

For some notes by Tanel Poder on "STATE", "SECONDS_IN_WAIT" and "WAIT_TIME" see
http://blog.tanelpoder.com/2007/06/18/advanced-oracle-troubleshooting-guide-when-the-wait-interface-is-not-enough-part-1/

Hemant K Chitale

At 08:50 PM Friday, Dunbar, Norman wrote:

>Hi Alex,
>
> >> If it was sql*net messages why the event shows db file
> >> sequential read?
>
>A good question.
>
>The 10g docs say that when the WAIT_TIME is non-zero that was the
>sessions last wait time. I think I may have misinterpreted that to take
>'last' to mean 'previous' - I do apologise.
>
>
>Clear as mud ??
>
>So, what does it mean when SECONDS_IN_WAIT is high and WAIT_TIME is -1 -
>which is what your problem appears to be?
>
>
>Cheers,
>Norman.

Hemant K Chitale
http://hemantoracledba.blogspot.com

--
http://www.freelists.org/webpage/oracle-l