BachPan,
Try these Kernel parameters:
bufpages Pages of static buffer cache â older parm 0
dbc_max_pct Max dynamic buffer cache between 3 and 10 % of memory
dbc_min_pct Min dynamic buffer cache between 2 and 5% of memory
maxfiles Soft limit for open files 1024
maxfiles_lim Hard limit for open files 1024 (default)
nfile Open files limit (15 * NPROC + 2048)
nflocks File lock limit (NPROC) (at least 4096)
ninode Max inodes in memory (8 * NPROC + 2048)
maxswapchunks Max swap space on the system 16384
swapmem_on Enable/disable pseudo-swap 1 (on)
swchunk Swap chunk size 4096 (up to 65536 for large RAM)
vps_ceiling Max page size in Kbytes 64
maxdsiz Max process data seg size for 32bit procs 1073741824 bytes or (0x40000000)
maxdsiz_64bit Max process data seg size for 64bit procs 2147483648 bytes or (0x80000000)
maxssiz Max process storage seg size for 32bit procs 134217728 bytes
maxssiz_64bit Max process storage seg size for 64bit procs 1073741824 bytes or (0x40000000)
maxtsize Max process text seg size 128MB
maxuprc Max # of procs/user ((NPROC*9)/10)
max_thread_proc Max threads/proc 256
nkthread Max kernel threads (((NPROC * 7) / 4) + 16)
nproc Max procs/system 4096
msgmap Message map size (2+msgmni)
msgmni Max msg queues nproc
msgseg # segs in msg queue 32767
msgtql Total msgs on system nproc
semmap Free sem map size (semmni+2)
semmni Max sems/system 4096
semmns Max sems for users/sys (semmni*2)
semmnu Max undos/sem (nproc-4)
semvmx Max sem value 32767
shmmax Max shared memory segment Large enough to hold the entire SGA in one shared memory segment (we use 32GB)
shmmni Max segments/system 512
shmseg Max segments/proc 120 per Oracle database
Or you may want to adopt the kernel paramters of the environments of the TPC runs at
www.tpc.org.
Hakuna Matata.
