Kernel paramters

[Pradep]

Hi,
can you please let me know what should be ideal kernel parameter settings, to run 5-10 oracle 11gR1 databases, on below config server

rx6600
8 cores - 1.42GHz
64 GB memory
hpux11iv3, Sep 2008 build.
oracle SGA - 1 Gb each

or anyone can share the params, if their server is running these many DBs.

thanks.

[Steven E. Protter · Accepted solution]

Shalom,

There are minimum parameters on the oracle.com websites.

Most common need in heavy duty servers is to increase shmmax to all of physical memory, reduce the file cache and set nfiles and such.

Here is a sample of a similar system that runs well.

Tunable Value Expression Changes
NSTREVENT 50 Default
NSTRPUSH 16 Default
NSTRSCHED 0 Default
STRCTLSZ 1024 Default
STRMSGSZ 65535 65535
acctresume 4 Default
acctsuspend 2 Default
aio_iosize_max 0 Default Immed
aio_listio_max 256 Default Immed
aio_max_ops 2048 Default Immed
aio_monitor_run_sec 30 Default Immed
aio_physmem_pct 10 Default Immed
aio_prio_delta_max 20 Default Immed
aio_proc_max 0 Default Immed
aio_proc_thread_pct 70 Default Immed
aio_proc_threads 1024 Default Immed
aio_req_per_thread 1 Default Immed
allocate_fs_swapmap 0 Default
alwaysdump 0 Default Immed
audit_memory_usage 5 Default Immed
audit_track_paths 0 Default Auto
base_pagesize 4 Default
copy_on_write 1 Default Immed
core_addshmem_read 0 Default Immed
core_addshmem_write 0 Default Immed
create_fastlinks 0 Default
default_disk_ir 0 Default
diskaudit_flush_interval 5 Default Immed
dlpi_max_clones 3992 Default Immed
dlpi_max_ub_promisc 1 Default Immed
dma32_pool_size 268435456 Default
dnlc_hash_locks 512 Default
dontdump 0 Default Immed
dst 1 Default
dump_compress_on 1 Default Immed
dump_concurrent_on 1 Default Immed
executable_stack 1 1 Immed
expanded_node_host_names 0 Default Immed
fcache_fb_policy 0 Default Immed
fcache_seqlimit_file 100 Default Immed
fcache_seqlimit_system 100 Default Immed
fcd_disable_mgmt_lun 0 Default Immed
fclp_ifc_disable_mgmt_lun 0 Default Immed
filecache_max 7346111692 15% Imm (auto disabled)
filecache_min 2448703897 5% Imm (auto disabled)
fr_statemax 800000 Default
fr_tcpidletimeout 86400 Default
fs_async 0 Default
fs_symlinks 20 Default Immed
ftable_hash_locks 64 Default
gvid_no_claim_dev 0 Default
hires_timeout_enable 0 Default Immed
hp_hfs_mtra_enabled 1 Default
intr_strobe_ics_pct 80 Default Immed
io_ports_hash_locks 64 Default
ipf_icmp6_passthru 0 Default
ipl_buffer_sz 8192 Default
ipl_logall 0 Default
ipl_suppress 1 Default
ipmi_watchdog_action 0 Default Immed
ksi_alloc_max 38912 38912 Immed
ksi_send_max 32 Default
lcpu_attr 0 Default Auto
max_acct_file_size 2560000 Default Immed
max_async_ports 4096 Default Immed
max_mem_window 0 Default Immed
max_thread_proc 1100 1100 Immed
maxdsiz 2040109465 2040109465 Immed
maxdsiz_64bit 8589934592 8589934592 Immed
maxfiles 2048 Default
maxfiles_lim 4096 Default Immed
maxrsessiz 8388608 Default
maxrsessiz_64bit 8388608 Default
maxssiz 16777216 16777216 Immed
maxssiz_64bit 268435456 Default Immed
maxtsiz 268435456 268435456 Immed
maxtsiz_64bit 1073741824 Default Immed
maxuprc 2500 2500 Immed
mca_recovery_on 0 Default Auto
msgmbs 8 Default Immed
msgmnb 65536 65536 Immed
msgmni 4864 4864 Immed
msgtql 14100 14100 Immed
ncdnode 150 Default
nclist 8292 Default
ncsize 46080 46080
nflocks 8000 8000 Imm (auto disabled)
nfs2_max_threads 8 Default Immed
nfs2_nra 4 Default Immed
nfs3_bsize 32768 Default Immed
nfs3_do_readdirplus 1 Default Immed
nfs3_jukebox_delay 1000 Default Immed
nfs3_max_threads 8 Default Immed
nfs3_max_transfer_size 1048576 Default Immed
nfs3_max_transfer_size_cots 1048576 Default Immed
nfs3_nra 4 Default Immed
nfs4_bsize 32768 Default Immed
nfs4_max_threads 8 Default Immed
nfs4_max_transfer_size 1048576 Default Immed
nfs4_max_transfer_size_cots 1048576 Default Immed
nfs4_nra 4 Default Immed
nfs_portmon 0 Default Immed
ngroups_max 20 Default Immed
ninode 40960 40960
nkthread 8528 8528 Immed
nproc 4864 4864 Immed
npty 500 500
nstrpty 500 500
nstrtel 500 500
nswapdev 32 Default
nswapfs 32 Default
numa_policy 0 Default Immed
pa_maxssiz_32bit 83648512 Default
pa_maxssiz_64bit 536870912 Default
pagezero_daemon_enabled 1 Default Immed
patch_active_text 1 Default Immed
pci_eh_enable 1 Default
pci_error_tolerance_time 1440 Default Immed
process_id_max 30000 Default Auto
process_id_min 0 Default Auto
pwr_idle_ctl 0 Default Immed
remote_nfs_swap 0 Default
rng_bitvals 9876543210 Default
rng_sleeptime 2 Default
rtsched_numpri 32 Default
sched_thread_affinity 6 Default Immed
scroll_lines 100 Default
secure_sid_scripts 1 Default Immed
semaem 16384 Default
semmni 16128 16128
semmns 32256 32256
semmnu 4860 4860
semmsl 2048 Default Immed
semume 256 256
semvmx 32767 Default
shmmax 1073741824 Default Immed
shmmni 1024 1024 Immed
shmseg 300 Default Immed
streampipes 0 Default
swchunk 2048 Default
sysv_hash_locks 128 Default
tcphashsz 0 Default
timeslice 10 Default
timezone 420 Default
uname_eoverflow 1 Default Immed
vnode_cd_hash_locks 128 Default
vnode_hash_locks 128 Default
vps_ceiling 16 Default Immed
vps_chatr_ceiling 1048576 Default Immed
vps_pagesize 16 Default Immed
vx_maxlink 32767 Default
vx_ninode 0 0 Immed
vxfs_bc_bufhwm 0 Default Immed
vxfs_ifree_timelag 0 Default Immed


SEP

[Tingli]

I think DBA usually have the minimum request for them during the Oracle installation from the manual. And for you, at least you should have shmmax larger than SGA.

[James R. Ferguson]

Hi:

The "ideal kernel parameter settings" can only be determined by *you* in *your* specific environment by measuring performance. Oracle has recommendations. A Google search turned up this:

http://www.scribd.com/doc/12775334/Oracle-RAC-11g-R1-On-HPUX

Regards!

...JRF...

[Pradep]

Thanks to all.

[Pradep]

Tunes shmmax and others