metalink note Note:265491.1
details how to determine the tunables .
----- Original Message ----
From: "Mercadante, Thomas F (LABOR)" <Thomas.Mercadante_at_labor.state.ny.us>
To: oracle-l <oracle-l_at_freelists.org>
Sent: Wednesday, February 21, 2007 8:06:19 AM
Subject: AIX Warning Message in DB Writer Trace File
All,
We are running Oracle 9.2.0.7 & 10.2.0.2 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.
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Feb 21 2007 - 09:31:02 CST
