Re: AIX parameters for Oracle

From: Matthias Hoys <anti_at_spam.com>
Date: Thu, 20 Jul 2006 21:19:08 +0200
Message-ID: <44bfd72c$0$1204$ba620e4c@news.skynet.be>

"astalavista" <nobody_at_nowhere.com> wrote in message news:44bfd23d$0$25331$636a55ce_at_news.free.fr...
> Hi,
>
> AIX 5.1 Oracle 9.2.0.4
>
> I have the following parameters:
> minservers 40
> maxservers 200
> maxreqs 4096
>
> I have often the following :
> Warning: lio_listio returned EAGAIN
> Performance degradation may be seen.
>
> According the documentation, i have to increase maxservers
> Is there any issue to set 300 for maxservers
> and maxreqs 8192 ?
>
> I plan to set , according the documentation,
> vmtune -c 8
> vmtune -r 32 -R 64 ( MINPGAHEAD, MAXPGAHEAD )
>
> Have you any experiences about these parameters ?
>
> Thanks in advance ...
>
>

Yes, you have to increase maxservers and maxreqs, and the error will go away. Don't forget to reboot the server for the new settings to become active.

PS : why are you still on AIX 5.1 ? There were some async i/o bugs fixed in 5.2, I don't think 5.1 is still supported by IBM. Received on Thu Jul 20 2006 - 14:19:08 CDT