RE: Error in trace file

Is this the: "Warning lio_listo returned EAGAIN" messages?

If they are then they can be produced by the AIX asynchronous I/O subsystem when the Async I/O buffer is full.

This shouldn't cause great alarm, as all this means is that Oracle has to re-request the write operation, although obviously this does introduce an overhead.

I have posted a rather incoherent post on this subject on my blog, although in my case I was using an older version of Oracle and AIX:

http://bigdaveroberts.wordpress.com/2007/07/12/eagain-again/

David Roberts

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Andrew Kerber Sent: 08 November 2007 14:43
To: oracle-l_at_freelists.org
Subject: Error in trace file

we are getting this error in a trace file, hundreds of times:

Warning: I/O request got either EINTR or EAGAIN

This is Oracle 9.2.0.8 64 bit on AIX. Can anyone shed some light on what this means?

--

Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'
--

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

This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you.
--

http://www.freelists.org/webpage/oracle-l Received on Thu Nov 08 2007 - 11:20:34 CST