many seconds waiting for I/O?

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

--

http://www.freelists.org/webpage/oracle-l Received on Fri Jul 27 2007 - 04:09:29 CDT