Re: Shared Memory Problem - Solaris 2.4 Oracle7.1.6

Usually, the following additions/modifications to your Solaris /etc/system file, followed by a reboot, should cure any shared memory hassles. Note that your choice of DB_BLOCK_SIZE in config.ora and your DB_BLOCK_BUFFERS maintain the majority of your SGA requirements. These Solaris parameters define the MAXIMUM number required. For instance, the shmmax parameter I have defined below allows a subroutine call to allocate at the most 256MB of space in shared memory.

Hope this helps ...

david

• ############# for Solaris 2.4
  *
  
• shared memory
  *
  set shmsys:shminfo_shmmax=268435456 set shmsys:shminfo_shmmni=256 set shmsys:shminfo_shmmin=1 set shmsys:shminfo_shmseg=100
  *
  
• semaphores
  *
  set semsys:seminfo_semmns=4096 set semsys:seminfo_semmni=4096 set semsys:seminfo_semume=64 set semsys:seminfo_semmap=256
  *
  
• messsage queues
  *
  set msgsys:msginfo_msgmap=2048 set msgsys:msginfo_msgmax=8192 set msgsys:msginfo_msgmnb=16384 set msgsys:msginfo_msgmni=50 set msgsys:msginfo_msgsez=32 set msgsys:msginfo_msgtql=2048 set msgsys:msginfo_msgseg=32767
  *
  

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
| david flinn                   workgroup solutions            |
| enterprise technology manager 76 blanchard road              |
| 617-238-8562                  burlington, ma 01803           |
| 617-229-9991 (fax)		david_at_wsi.com                  |
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++