SHM_SHARE_MMU segment warning [message #60394] |
Thu, 05 February 2004 12:00 |
James Briar
Messages: 72 Registered: January 2002 Location: Morden (South London)
|
Member |
|
|
I'm getting the following warning message in one of the alert logs after i shutdown/startup the instance :-
Completed: alter database close
Thu Feb 5 19:30:08 2004
alter database dismount
Completed: alter database dismount
archiving is disabled
Thu Feb 5 19:30:14 2004
Starting ORACLE instance (normal)
Thu Feb 5 19:30:15 2004
WARNING: Not enough physical memory for SHM_SHARE_MMU segment of size 0x00000000
06144000
This is not causing any problems but i'd like to fix this warning. I've amended the Unix Kernel for the number of Oracle instances correctly (amending the file /etc/system etc). We're using Oracle 8i on Unix Sun Solaris 8. Has anyone come across this warning before?
|
|
|
Re: SHM_SHARE_MMU segment warning [message #60397 is a reply to message #60394] |
Thu, 05 February 2004 14:41 |
Thiru
Messages: 1089 Registered: May 2002
|
Senior Member |
|
|
You can try reducing the SGA size( db_block_buffers , shared_pool_size etc) or disable intimate shared memory by setting USE_ISM=false(note that ism allows multiple processes to share the page table). This warning is raised becos your SGA is not able to fit into the phyiscal memory which is required by ISM.
-Thiru
|
|
|
|