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
Other related posts:
