Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: AIX Warning Message in DB Writer Trace File

Re: AIX Warning Message in DB Writer Trace File

From: Fuad Arshad <>
Date: Wed, 21 Feb 2007 07:31:02 -0800 (PST)
Message-ID: <>

metalink note Note:265491.1 details how to determine the tunables . ----- Original Message ---- From: "Mercadante, Thomas F (LABOR)" <> To: oracle-l <> Sent: Wednesday, February 21, 2007 8:06:19 AM Subject: AIX Warning Message in DB Writer Trace File All, We are running Oracle & on Aix 5.2. I am seeing the following warnings in the DB Writer trace file: Warning: lio_listio returned EAGAIN Performance degradation may be seen. The following unix parameters are as follows: # date Fri Feb 16 12:46:43 EST 2007 # pstat -a | grep -c aios 101 Current system parameters: # lsattr -El aio0 autoconfig available STATE to be configured at system restart True fastpath enable State of fast path True kprocprio 39 Server PRIORITY True maxreqs 4096 Maximum number of REQUESTS True maxservers 10 MAXIMUM number of servers per cpu True minservers 1 MINIMUM number of servers True It looks like we should increase the maxservers and minservers parameter. Has anyone else seen this? Any suggestions as to what I should set maxservers to? It looks like a value of 300 would be a good start according to an IBM web site. Does this make sense? Thanks Tom This transmission may contain confidential, proprietary, or privileged information which is intended solely for use by the individual or entity to whom it is addressed. If you are not the intended recipient, you are hereby notified that any disclosure, dissemination, copying or distribution of this transmission or its attachments is strictly prohibited. In addition, unauthorized access to this transmission may violate federal or State law, including the Electronic Communications Privacy Act of 1985. If you have received this transmission in error, please notify the sender immediately by return e-mail and delete the transmission and its attachments.

Received on Wed Feb 21 2007 - 09:31:02 CST

Original text of this message