Kernel Changes

[Nobody's Hero]

I am getting ready to upgrade to oracle 9i. I am trying to find the kernel parm requirements for my n4000 to run 9i. I am also having trouble finding the patches for 9i. Any help would be appreciated.

[Uday_S_Ankolekar]

If you have access to metalink site then I please refer that site. I guess it has doc id: 169706.1
Here is the extract for kernel paramter requirement fro the doc.

MAX_THREAD_PROC 256
MAXDSIZ 1073741824 bytes
MAXDSIZ_64BIT 2147483648 bytes
MAXSSIZ 134217728 bytes
MAXSSIZ_64BIT 1073741824
MAXSWAPCHUNKS 16384
MAXUPRC ((NPROC*9)/10)
MSGMAP (MSGTQL+2)
MSGMNI NPROC
MSGSEG 32767
MSGTQL NPROC
NCALLOUT (NKTHREAD+16)
NCSIZE ((8*NPROC+2048)+VX_NCSIZE)
NFILE (15*NPROC+2048)
NFLOCKS 4096
NINODE (8*NPROC+2048)
NKTHREAD (((NPROC*7)/4)+16)
NPROC 4096
SEMMAP (SEMMNI+2)
SEMMNI 4096
SEMMNS (SEMMNI*2)
SEMMNU (NPROC - 4)
SEMVMX 32768
SHMMAX AvailMem
SHMMIN 1
SHMMNI 512
SHMSEG 32
VPS_CEILING 64

Goodluck,
-USA..

[Stanimir]

There is for Oracle 9!:


STRMSGSZ 65535
bufpages 0
create_fastlinks 1
dbc_max_pct 25
dbc_min_pct 2
dnlc_hash_locks 512
maxdsiz 0X80000000
maxdsiz_64bit 0X40000000
maxfiles 2048
maxfiles_lim 2048
maxssiz 0X5000000
maxssiz_64bit 0X5000000
maxswapchunks 16384
maxtsiz 0X40000000
maxtsiz_64bit 0X40000000
maxuprc ((NPROC*8)/10)
maxusers 400
maxvgs 80
msgmap (MSGTQL+2)
TRMSGSZ 65535
bufpages 0
create_fastlinks 1
dbc_max_pct 25
dbc_min_pct 2
dnlc_hash_locks 512
maxdsiz 0X80000000
maxdsiz_64bit 0X40000000
maxfiles 2048
maxfiles_lim 2048
maxssiz 0X5000000
maxssiz_64bit 0X5000000
maxswapchunks 16384
maxtsiz 0X40000000
maxtsiz_64bit 0X40000000
maxuprc ((NPROC*8)/10)
maxusers 400
maxvgs 80
msgmap (MSGTQL+2)
msgmax 32768
msgmnb 65535
msgmni (NPROC)
msgseg (MSGTQL*4)
msgssz 128
msgtql (NPROC)
nfile (15*NPROC+2048)
nflocks (NPROC)
ninode (8*NPROC+2048)
nproc (((10*MAXUSERS)/3)+128)
nstrpty 60
nstrtel (MAXUSERS)
nswapdev 25
semmni (NPROC*2)
semmns (SEMMNI*2)
semmnu (NPROC-4)
semume 64
semvmx 32768
shmmax 0X280000000
shmmni 512
shmseg 32
timeslice 10
unlockable_mem (MAXUSERS*10)

[Nobody's Hero]

before I supply points, can you tell me why these parms need to be so low. Mine are much higher. Why so low?

SHMMIN 1
SHMMNI 512
SHMSEG 32
VPS_CEILING 64

[Steven E. Protter · Accepted solution]

SHMSEG needs to be higher.

What seems to have been posted ar minimums from Oracle's metalink database. Oracle seems to assume nothing else runs on the box but their stuff.

I'm attaching a working kernel configuration kmtune output from a box that Runs 9.2.0.4 and ias 10G

SEP

[Victor BERRIDGE]

Hi,
I agree with Steven, you need for SHMSEG at least 150 (thats for 1-2 small instances) more reasonable is to set it at >200...
e.g.
semmni 4306
semmns 8612
semmnu 4112
semume 30
shmmax 1073741824
shmmni 512
shmseg 200
st_large_recs 1
swchunk 4096
sysv_hash_locks 200
vps_ceiling 64

All the best
Victor