'oracle'에 해당되는 글 2건
- 2008.01.02 oracle memory
- 2007.11.15 linux 커널 파라미터
- os
1. Application Serve 설치시 커널 파라미터 권고안 (Oracle 기준)
maxdsize : 67MByte * (Message store(GB) / 4)
maxswapchunks : > swap space(MB)/2
maxuprc : > 256 * 보조 process 개수
nproc : #LOG * 2 + 10
ncallout : >= nproc
nfile : #LOG * 45
maxfiles : > 256
ninode : #ACT * 45
nflocks : #ACT * 1
msgssz : 32
msgtql : #ACT + 30
msgmap : msgtql + 2
msgmnb : 65535
semmnu(Number of Semaphore Undo Structures) : = nproc
shmmni : default + 15
maxusers : > #TOT
shmmax(Max Shared Mem Segment) : > 167772160
maxssiz(Max Stack Segment Size) : > 16777216
** 일반적인 kernel parameter setting
maxdsiz o x 1 0 0 0 0 0 0 0 (268,435,456)
maxdsiz_64bit o x 0 0 0 0 0 0 3 f f b f f f f f f f (4,396,970,769,279)
maxssiz_64bit o x 0 0 8 0 0 0 0 0 (8,388,608)
maxtsiz_64bit o x 0 4 0 0 0 0 0 0 (67,108,864)
shmmax o x 2 0 0 0 0 0 0 0 (536,870,912)