'oracle'에 해당되는 글 2건

  1. 2008.01.02 oracle memory
  2. 2007.11.15 linux 커널 파라미터

oracle memory

DB/oracle 2008. 1. 2. 09:07
http://www.pythian.com/blogs/741/pythian-goodies-free-memory-swap-oracle-and-everything
Posted by foryamu
,

linux 커널 파라미터

DB/oracle 2007. 11. 15. 16:51

- 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)

Posted by foryamu
,