Total Memory allocation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Total Memory allocation

  1. #1
    Join Date
    Apr 2005
    Posts
    15

    Total Memory allocation

    hi

    we are running 9i database on windows 2k. the server has 4gb memory on it. When i allocate anything more than 2GB as total memory to oralce, i am getting error as insufficient memory.

    a) Is this because the OS cannot allocate more than 2GB? (i read somewhere that windows by default wont allocate more than 2GB!)

    b) can we allocate more than 2GB to daatbase if the server gets another 4GB memory?

    thanks.

    regards,
    Sudhi

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    search for extended memory for windows

  3. #3
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    On windows the problem is not exactly how big the SGA can be but how big the process memory can be. The maximum value is only limited by how much address space you have in your Oracle process, and how much memory you have in the machine. You can go upto 3 GB (refer to Microsoft Article ID:Q171793), but due address space fragmentation, it is often not possible to push the envelope on address space usage, so if you try to allocate a huge SGA, you may get failures even if you have enough memory
    =================================
    The SGA value is limited by how much address space you have in your Oracle process, and how much memory you have in the machine. Prior to NT4.0 SP3, you were limited to 2GB of address space per process so physical memory exceeding 2GB would not benefit Oracle. However, now
    Oracle can address up to 3GB on Windows 2000 ADVANCED Server and Windows NT 4.0 Enterprise Edition as long as the /3GB switch is set in the boot.ini file. As a general rule, we do not recommend you allocate more than 50% of your available memory for the SGA.
    Thanks and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com

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