Huge "shmmax" & tiny "shared_memory_size"

From: Ben <bozothedeathmachine_at_excite.com>
Date: 7 Jan 2003 10:09:54 -0800
Message-ID: <3922f5b.0301071009.b94bc66@posting.google.com>

We are running Oracle 8 or Solaris 7. In the /etc/system I have shmsys:shminfo_shmmax=4294967295, which is the amount of memory we have. However the shared_memory_size is only 9000000. Aren't these kind of disparate numbers? Granted there is only 1 user for the database with really no more than 50 threads. But we are getting shared memory errors and I was wondering if it would stem from this.

Detailed info below.

Thanks for the assistance.

/etc/system

set msgsys:msginfo_msgmnb=65536
set msgsys:msginfo_msgmax=8192
set msgsys:msginfo_msgtql=2048
set msgsys:msginfo_msgmap=2050
set msgsys:msginfo_msgssz=128
set msgsys:msginfo_msgseg=16384
set msgsys:msginfo_msgmni=256

set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmseg=120

set shmsys:shminfo_shmmni=200
set shmsys:shminfo_shmmin=1

set semsys:seminfo_semmns=1750
set semsys:seminfo_semmni=280
set semsys:seminfo_semmap=282
set semsys:seminfo_semmnu=500
set semsys:seminfo_semmsl=510
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767  
---------------------------------------
Oracle init file
sort_area_size                =  262144
sort_area_retained_size       =   65536
db_file_multiblock_read_count =      16
db_block_buffers              =    4096
shared_pool_size              = 9000000
log_checkpoint_interval       =   10000
processes                     =      50
dml_locks                     =     200
log_buffer                    =  163840
sequence_cache_entries        =     100
sequence_cache_hash_buckets   =      23

Received on Tue Jan 07 2003 - 12:09:54 CST