Fandom

BrainScraps Wiki

HPUX Tunes for Oracle

21pages on
this wiki
Add New Page
Comments0 Share

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.

~ HPUX Tune ~ Value/Formula ~ Tune Description
executable_stack 0 Controls whether program stacks are executable by default.
ksi_alloc_max (NPROC*8) System-wide limit of queued signals that can be allocated.
max_thread_proc 1024 Defines the maximum number of concurrent threads allowed per process.
maxdsiz 1073741824 Maximum size (in bytes) of the data segment for any 32bit user process.
maxdsiz_64bit 2147483648 Maximum size (in bytes) of the data segment for any 64bit user process.
maxssiz 134217728 Maximum size (in bytes) of the stack for any 32bit user process.
maxssiz_64bit 1073741824 Maximum size (in bytes) of the stack for any 64bit user process.
maxswapchunks 16384 Maximum number of swap chunks which can be managed by swap system. (<11.23)
maxuprc ((NPROC*9)/10)+1 Limits the maximum number of concurrent user processes per user.
msgmap (MSGTQL+2) Number of entries in the System V IPC message space resource map. (<11.31)
msgmni (NPROC) Maximum number of system-wide System V IPC message queues (IDs) allowed.
msgseg 32767 Number of System V IPC message segments in the system. (<11.31)
msgtql (NPROC) Maximum number of System V IPC messages in the system at any time.
ncallout (NKTHREAD+16) Size of the kernel callout table. (<11.23)
ncsize (NINODE+1024) Number of Directory Name Lookup Cache (DNLC) entries.
nfile (15*NPROC+2048) Maximum number of open files (system-wide). (<11.31)
nflocks (NPROC) Maximum number of file locks.
ninode (8*NPROC+2048) Maximum number of HFS file system open inodes that can be in memory.
nkthread (((NPROC*7)/4)+16) Limits the number of threads allowed to run simultaneously.
nproc 4096 Limits the number of processes allowed to exist simultaneously.
semmap (SEMMNI+2) Number of entries in a System V IPC semaphore map. (<11.23)
semmni (NPROC) Number of System V IPC system-wide semaphore identifiers.
semmns (SEMMNI*2) Number of System V IPC system-wide semaphores.
semmnu (NPROC-4) maximum Number of System V IPC undo structures for processes.
semvmx 32767 Maximum value of any single System V IPC semaphore.
shmmax The largest single SGA size of all instances. Maximum size (in bytes) for a System V shared memory segment.
shmmni 512 Number of System V shared memory segment identifiers in the system.
shmseg 120 Maximum number of System V shared memory segments per process.
vps_ceiling 64 Maximum (in kilobytes) of system-selectable page size

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'))"

Ad blocker interference detected!


Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers

Wikia is not accessible if you’ve made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected.