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
1.75Gb unless you start playing around to get extra with AWE / hugemem for example
1.75GB for what PGA or SGA?
Isn't on Linux the PGA owned by the session process?
1.75 Gb for the SGA
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
Davey I think it is 1.7GB combination of SGA and PGA since the memory is per process.
Isn't the PGA attached to the session process?
everything is attached to oracle.exe
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
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