Thursday 12 April 2012

AIX Standard Tunnable Parameters

This is standard AIX Tunable Parameters for AIX 5.3 & 6.1 Series,
It's the best practice to use this parameters for the better performance., It's also depends on your environment.

Also 'AIO' is an important tunable parameter in Oracle DB Servers.,
For setting this Minservers & Maxservers value, we have to do such calculations.

minservers = 10 * # cpus
maxservers = (10 * # disks) / # cpus
maxreqs = a multiple of 4096 > 4 * #disks * queue_depth


For Application & DB Servers

Network Related Parameters :

no -a |egrep "tcp_finwait2|tcp_keepidle|tcp_keepinit|tcp_keepintvl|tcp_timewait|sb_max|rfc1323|use_isno|tcp_recvspace|tcp_sendspace|udp_recvspace|udp_sendspace"|sort

Memory Related Parameters :

vmo -a |egrep "lru_file_repage|lru_poll_interval|maxclient%|maxfree|maxperm%|minfree|minperm%"|sort

IO Related Parameters :

ioo -a |egrep "j2_maxPageReadAhead|j2_maxRandomWrite|j2_nBufferPerPagerDevice|j2_nPagesPerWriteBehindCluster|maxpgahead|maxrandwrt|numfsbufs|pv_min_pbuf"|sort

AIO Related Parameters :

aioo -a