many seconds waiting for I/O?

From: amonte <ax.mount@xxxxxxxxx>
To: oracle-l <oracle-l@xxxxxxxxxxxxx>
Date: Fri, 27 Jul 2007 11:09:29 +0200

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

Follow-Ups:

RE: many seconds waiting for I/O?
From: Dunbar, Norman

many seconds waiting for I/O?

Other related posts: