Re: Shared Memory Segments on Solaris 2.5.1

Dave wrote:
>
> Can anyone advise on the most efficient settings for
> Shared Memory Segments on Solaris 2.5.1 and Oracle 7.3.3
> Sparc Centre 2000 with 4 cpu's and 256MB ram.
> The installation manual for Oracle has recommended values but
> does not indicate whether these are dependant on your physical
> ram.
>
> Installation manual
> SHMMAX 8388608
> SHMMIN 1
> SHMMNI 100
> SHMSEG 10
> SEMMNS 200
> SEMMNI 70
>
> Dave

Dave
Personnally I always put large numbers here. One of my /etc/system files has this in it...

set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=1024
set shmsys:shminfo_shmseg=1024
set semsys:seminfo_semmap=1002
set semsys:seminfo_semmni=500
set semsys:seminfo_semmns=400
set semsys:seminfo_semmnu=500
set semsys:seminfo_semmsl=500
set semsys:seminfo_semopm=100
set semsys:seminfo_semume=100
set semsys:seminfo_semusz=256
set semsys:seminfo_semvmx=32767
set semsys:seminfo_semaem=16384

Basically setting arbitarily large values has little impact on the performance of the system, but its an issue when you've maxed out in the db_block_buffers/shared_pool_size in Oracle and you have to edit /etc/system and reboot, rather than just edit init.ora to your hearts content.

Martin Received on Tue Nov 02 1999 - 07:28:42 CST