max SGA/PGA size on a 32bit linux/windows server
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: max SGA/PGA size on a 32bit linux/windows server

Hybrid View

  1. #1
    Join Date
    Mar 2002
    Posts
    534

    max SGA/PGA size on a 32bit linux/windows server

    Hi,

    I was wondering which ist the maximum SGA and PGA size which can be set on a linux and windows 32 bit server?

    Thanks for any input
    Mike

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    1.75Gb unless you start playing around to get extra with AWE / hugemem for example

  3. #3
    Join Date
    Mar 2002
    Posts
    534
    1.75GB for what PGA or SGA?

    Isn't on Linux the PGA owned by the session process?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    1.75 Gb for the SGA

  5. #5
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    windooze has a 64 bit OS now where you can create sga >2gb on a 32bit chipset
    I'm stmontgo and I approve of this message

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Davey I think it is 1.7GB combination of SGA and PGA since the memory is per process.

  7. #7
    Join Date
    Mar 2002
    Posts
    534
    Hi Pando,

    Isn't the PGA attached to the session process?

  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    Hi

    everything is attached to oracle.exe

  9. #9
    Join Date
    Oct 2006
    Location
    Mumbai
    Posts
    184
    In Linux:

    Procedure how to increase the SGA in LINUX AS/ES 3.


    1. Shutdown the Database.

    2. Add following kernel parameter in /boot/grub/grub.conf

    Kernel /vmlinuz-2.6.9-34.ELsmp ro root=LABEL=/ rhgb quiet bigpages=6100 MB

    Edit and Add following parameter in /etc/sysctl.conf

    Kernel.shmmax = 4294967295 (not more then it)

    3. Add following parameter in init.ora file:


    Sample calculation for 2GB of db_block_buffers

    (1024*1024*1024)*2/db_block_size (8192) = 262144


    Instead of db_cache_size used following parameter

    db_block_buffers=262144
    use_indirect_data_buffers=true

    4. Restart the Linux server.

    5. Up the database and see SGA

    SQL> show sga


    Total System Global Area 3407418688 bytes
    Fixed Size 451904 bytes
    Variable Size 1258291200 bytes
    Database Buffers 2147483648 bytes
    Redo Buffers 1191936 bytes

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