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

[mike9]

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

[davey23uk]

1.75Gb unless you start playing around to get extra with AWE / hugemem for example

[mike9]

1.75GB for what PGA or SGA?

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

[davey23uk]

1.75 Gb for the SGA

[stmontgo]

windooze has a 64 bit OS now where you can create sga >2gb on a 32bit chipset

[pando]

Davey I think it is 1.7GB combination of SGA and PGA since the memory is per process.

[mike9]

Hi Pando,

Isn't the PGA attached to the session process?

[pando]

Hi

everything is attached to oracle.exe

[pareshjavkar]

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