Re: AIX parameters for Oracle

From: Andreas Piesk <a.piesk_at_gmx.net>
Date: 22 Jul 2006 02:14:16 -0700
Message-ID: <1153559656.344911.131030@p79g2000cwp.googlegroups.com>

astalavista wrote:
> > astalavista wrote:
> >> I have the following parameters:
> >> minservers 40
> >> maxservers 200
> >> maxreqs 4096
> >
> 2 CPU
> 5 x 2 disks

300 aixprocs is quite a lot for 10 disks. must be very fast disks with an average seek time of 3-4 ms if i didn't miscount. have you benchmarked your system to see if increasing maxservers would improve IO/s ?
i would start with maxservers=100 and check IO/s using vmstat or similar tool. then increase maxservers and check IO/s again. repeat until IO/s stop increasing.
this is the right maxservers parameter for your system. to get rid of the warning message increase maxreqs.
i used this method on our 2 RAC-Clusters and both perform very well (and no LIO related messages).

regards,
-ap Received on Sat Jul 22 2006 - 04:14:16 CDT