2006/10/04

Solaris 10 project configuration for Large OLTP DB server(oracle)

Solaris 10 project configuration for Large OLTP DB server(oracle)

-
This summary is a fine idea....
For high-performance OLTP DB server I also set additional project values
in order to be able to sustain a large amount (>1024) of sessions and
terminals. They are included below :

user.oracle:100:Oracle:::process.max-sem-nsems=(privileged,1024,deny);
project.max-file-descriptor=(privileged,8192,deny);
project.max-msg-ids=(privileged,8192,deny);
project.max-sem-ids=(privileged,4096,deny);
project.max-shm-ids=(privileged,512,deny);
project.max-shm-memory=(privileged,137438953472,deny);
task.max-lwps=(privileged,8192,deny)