HPUX Tunes for Oracle

Mbm329 05:57, March 12, 2012 (UTC)

Here is a list of recommended (by Oracle) HPUX kernel tunables. These tunes should work with 10g and 9i. Depending on your systems and how your database performs, YMMV.

Depending on your version of HPUX, copy/paste the following to see what your tunes are currently set to. HPUX <= 11.11:

parameters="executable_stack ksi_alloc_max max_thread_proc maxdsiz maxdsiz_64bit maxssiz maxssiz_64bit maxswapchunks maxuprc msgmap msgmni msgseg msgtql ncallout ncsize nfile nflocks ninode nkthread nproc semmap semmni semmns semmnu semvmx shmmax shmmni shmseg vps_ceiling" kmtune | grep -i "^($(echo ${parameters} | sed 's/\ /\|/g'))"

HPUX >= 11.23:

parameters="executable_stack ksi_alloc_max max_thread_proc maxdsiz maxdsiz_64bit maxssiz maxssiz_64bit maxswapchunks maxuprc msgmap msgmni msgseg msgtql ncallout ncsize nfile nflocks ninode nkthread nproc semmap semmni semmns semmnu semvmx shmmax shmmni shmseg vps_ceiling" kctune | grep -i "^($(echo ${parameters} | sed 's/\ /\|/g'))"