Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

AIX Warning Message in DB Writer Trace File

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Wed, 21 Feb 2007 09:06:19 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08B66@EXCNYSM0A1AJ.nysemail.nyenet>


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 - 08:06:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US