SGA_MAX_SIZE limit for Oracle 10g 32BIT on Linux Red Hat
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: SGA_MAX_SIZE limit for Oracle 10g 32BIT on Linux Red Hat

  1. #1
    Join Date
    Dec 2001
    Posts
    337

    SGA_MAX_SIZE limit for Oracle 10g 32BIT on Linux Red Hat

    Hi all,

    We have a 32 Bit 10g database installed on Linux Redhat. The server has 4GB physical memory and only runs Oracle. Our SGA_MAX_SIZE parameter was set to 1.4GB, we need to increase this to 2GB. However when we tried to do restart the instance after the change, we got the following error:

    ORA-27123: unable to attach to shared memory segment

    Now i have checked the kernel parameters and these seem to be set fine, so i am wondering if i am hitting a limit for a 32 bit Oracle install?

    Any advice will be much appreciated.

    Thanks in advance,
    Chucks

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    it turns out 32 bit cannot address more than 2GB memory space, you have seevral options, check them out on Metalink

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    You may be able to tweak your kernel parameters up to about 1.7 without any of the tricks in metalink, but in general, metalink tells you how to get to 2G. If you think you need something more, consider 64bit.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Jun 2007
    Location
    İstanbul/Turkey
    Posts
    25
    Raise SHMMAX in /etc/system or Lower SHARED_POOL_SIZE or lower
    DB_BLOCK_BUFFERS accordingly.

  5. #5
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    This metalink Note may help you.
    115753.1
    http://www.perf-engg.com
    A performance engineering forum

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