General OLTP/Database Monolithic System # # Format: # 1st line = title of tuned parameter set # # Lines or words (delimited by white space) beginning with # are comments. # # Blank lines are ignored. # # Parameter defs can take either of two forms: # 1. parameter min max # The parameter's value must fall into the range of min-max, # inclusive. If parameter is less than min, it is raised to # min; if greater than max, it is lowered to max. Otherwise # it is left unchanged. # # Min and/or max can be "--" (two dashes), indicating there is no # corresponding lower and/or upper bound, respectively. # # Min and/or max can be arithmetic formulas, and can reference # other parameters. Any parameters referenced in a formula must # already be defined earlier in the parameter set. No white # space may occur within a formula. Parentheses are recognized # and can be nested. # # 2. parameter value # The parameter's value will be set to the value given. Value # can be an arithmetic formula as described above. # maxusers 400 nproc (((10*maxusers)/3)+128) bufpages 0 nbuf 0 dbc_min_pct 5 dbc_max_pct 20 maxfiles 2048 maxfiles_lim 2048 nfile (15*nproc+2048) nflocks (nproc) ninode (8*nproc+2048) msgtql (nproc) msgmap (msgtql+2) msgmax 32768 msgmnb 65535 msgmni (nproc) msgssz 128 msgseg (msgtql*4) semaem 16384 semmni (nproc*2) semmap (semmni+2) semmns (semmni*2) semmnu (nproc-4) semume 64 semvmx 32768 shmmax 0x40000000 shmmni 512 shmseg 32 maxvgs 80 maxswapchunks 4096 nswapdev 25 swapmem_on 0 unlockable_mem (maxusers*10) maxuprc ((nproc*8)/10) timeslice 1 npty (maxusers) sema 1 mesg 1 shmem 1 no_lvm_disks 0