-
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
-
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?
-
-
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.
-
Hi Pando,
Isn't the PGA attached to the session process?
-
Hi
everything is attached to oracle.exe
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|