Re: many seconds waiting for I/O?

It would be interesting to see the actual SQL Query that you used to generate this list.
Which views have you joined together ? At what interval did you generate these snapshots ?
Why do I ask ?
How do you get Consistent_Gets being reported with Wait_Time and Seconds_In_Wait ?
Your Consitent_Gets are increasing but the Seq# remains the same. There is some inconsistency in your listing.

Hemant

At 05:09 PM Friday, amonte wrote:
>Hi
>
>I have a batch process running and it seems that it's waiting for
>I/O all the time, the strange thing is it shows 400 seconds waits!
>
>EVENT CONSISTENT_GETS SPID WAIT_TIME
>SECONDS_IN_WAIT STATE SEQ#
>-------------------------- --------------- ------------ ----------
>--------------- ------------------- ----------
>db file sequential read 212532
>25879 -1 374 WAITED SHORT TIME 892
>
>
>EVENT CONSISTENT_GETS SPID WAIT_TIME
>SECONDS_IN_WAIT STATE SEQ#
>-------------------------- --------------- ------------ ----------
>--------------- ------------------- ----------
>db file sequential read 212717
>25879 -1 431 WAITED SHORT TIME 892
>
>
>EVENT CONSISTENT_GETS SPID WAIT_TIME
>SECONDS_IN_WAIT STATE SEQ#
>-------------------------- --------------- ------------ ----------
>--------------- ------------------- ----------
>db file sequential read 212925
>25879 -1 504 WAITED SHORT TIME 892
>
>What can cause this???
>
>Thanks!
>
>Alex

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

"First they ignore you, then they laugh at you, then they fight you, then you win" !"
Mohandas Gandhi Quotes
: http://www.brainyquote.com/quotes/authors/m/mohandas_gandhi.html

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