Thursday, September 22, 2011

Oracle SGA and PGA fine tuning

If the system memory is insufficient due to Oracle memory allocation, 1st link will show how the PGA and SGA memory allocation is calculated. 2nd link will show how to set the memory.

http://www.dba-oracle.com/art_dbazine_ram.htm
http://orafaq.com/wiki/SGA_target

Click here to view the full explanation on Memory Architecture from Oracle for 11gR2.

No comments:

Post a Comment