-
warring :not enough physical memory for SHM_SHARE_MMU
hello all:
ultra 2 ORACLE 8.1.7.4
when I start the database, the warring in the alert.log
WARNING: Not enough physical memory for SHM_SHARE_MMU segment of size 0x00000000
0ae44000
the /etc/system
set semsys:seminfo_semmap=250
set semsys:seminfo_semmni=1000
set semsys:seminfo_semmns=5000
set semsys:seminfo_semmsl=500
set semsys:seminfo_semmnu=500
set semsys:seminfo_semume=100
set shmsys:shminfo_shmmax=209715200set
shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=200
set shmsys:shminfo_shmmin=1
set msgsys:msginfo_msgmni=50
set msgsys:msginfo_msgmnb=16384
the initial.ora
DB_BLOCK_SIZE=8192
DB_BUFFERS=12800
LOG_BUFFER=32768
SHARED_POOL_SIZE =50MB
please help me analyse the problem and present the solution!
Thanks in advance
-
Oracle recommended values for Unix Kernal parameters are:
set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=100
set semsys:seminfo_semmns=200
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767
I hope this will help you...
Thanks,
________________
ShanDJ
-
Hi,
shandj is correct, Oracle recommends these parameters, but the parameters need to reflect your database and machine characteristics.
UNIX Kernel Parameters:
SHMMAX = 4294967295 (This setting indicates the maximum allowable size)
SHMMIN = 1
SHMMNI = 100
SHMSEG = 10
Semaphores:
SEMMNI = 100
SEMMNS = [(largest PROCESSES parameter of any database) * 2 + (other instance processes)] + [(# of instances) * 10]
SEMMSL = 10 + largest PROCESSES parameter.
SEMOPM = 10
SEMVMX = 32767
Cheers,
R.
It is better to ask and appear ignorant, than to remain silent and remain ignorant.
Oracle OCP DBA 9i,
C++, Java developer
-
Alternatively you can reduce the SGA settings in init.ora.
Agasimani
OCP(10g/9i/8i/8)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|