WARNING:Oracle process running out of OS kernel I/O resources (1)
764175Sep 1 2010 — edited Sep 1 2010Hi,
on my server, IBM power6, with oracle 10.2.0.4, dbwr trace report some errors like this:
*** 2010-08-31 06:26:46.574
Warning: lio_listio returned EAGAIN
Performance degradation may be seen.
WARNING:Oracle process running out of OS kernel I/O resources (1)
*** 2010-09-01 07:11:38.691
Warning: lio_listio returned EAGAIN
Performance degradation may be seen.
WARNING:Oracle process running out of OS kernel I/O resources (1)
The awr in this period of time reports:
Top 5 Timed Events Avg %Total
~~~~~~~~~~~~~~~~~~ wait Call
Event Waits Time (s) (ms) Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
db file sequential read 509,435 2,610 5 42.3 User I/O
CPU time 1,714 27.8
log file sync 55,309 1,146 21 18.6 Commit
log file parallel write 60,498 937 15 15.2 System I/O
db file parallel write 27,166 295 11 4.8 System I/O
-------------------------------------------------------------
The workload was represented from a sqlldr with rows=100000.
Warning in trace file worry me.
Warning: lio_listio returned EAGAIN
depends on aioserver that is low, 10 instead 50, because we have 40disks*10/8 cpu.
Can anyone help me?