warring :not enough physical memory for SHM_SHARE_MMU
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: warring :not enough physical memory for SHM_SHARE_MMU

  1. #1
    Join Date
    Oct 2002
    Posts
    17

    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

  2. #2
    Join Date
    Feb 2002
    Posts
    70
    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

  3. #3
    Join Date
    Nov 2000
    Location
    Israel
    Posts
    268
    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

  4. #4
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    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
  •  



Click Here to Expand Forum to Full Width