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

Other related posts: