Kernel parameter for oracle ...

From: Scott D. Yelich <scott_at_scottyelich.com>
Date: Thu, 06 Sep 2001 18:08:34 -0600 (MDT)

Hello list....

Does anyone have an opinion on these kernel parameters for
Tru64 5.1 2GB or greater, 2,4 and 8 cpu machines?

For DSS/OLTP:
vm: Setting Physical Memory Limit

    ubc_minpercent=1
    ubc_maxpercent=2
    vm_swap_eager=0
    vm_page_free_target = 768 (upto 4G) 1024 (above 4G)

proc: Setting Process Limits

    max_users=2048
    max_proc_per_user=1024
    max_threads_per_user = 1024 (4096 for portal server)
    per_proc_data_size=MACHINE_PHYSICAL_MEMORY_SIZE
    max_per_proc_data_size=MACHINE_PHYSICAL_MEMORY_SIZE
    per_proc_address_space=MACHINE_PHYSICAL_MEMORY_SIZE
    max_per_proc_address_space=MACHINE_PHYSICAL_MEMORY_SIZE

ipc: Interprocess Communication (IPC)/Shared Memory Limits

    shm_max=2139095040
    shm_seg=32
    msg_max=8192
    msg_mnb=16384
    msg_mni=1024
    msg_tql=4096
    ssm_threshold=0
    sem_mni=2048
    sem_msl=2048
    sem_opm=400
    sem_ume=400

For Oracle App. 11i:
proc: Setting Process Limits

    max_proc_per_user=2048
    max_threads_per_user = 2048


Thanks!

Scott
Received on Fri Sep 07 2001 - 00:23:01 NZST