Call (800) 766-1884 for Oracle support & training
Free Oracle Tips

Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance

Free Oracle Tips



BC Oracle tuning

Oracle training

Oracle support

Remote Oracle


Overview of Oracle SGA Regions

Donald K. Burleson



Overview of the Oracle SGA Regions

When an Oracle database is started, the Oracle executable issues the malloc( ) command to create a region of RAM memory.  The SGA is commonly called the Oracle region because it is a region of RAM memory on the database server RAM heap.

The Oracle DBA controls the size of the SGA, and proper SGA management can have a huge impact on performance.  However, we must remember that the SGA is a static memory region, and the needs of the Oracle database are constantly changing.  Until Oracle, the SGA was not dynamic and could not be altered.  After Oracle became commonplace in 2002, the dynamic adjustment of the SGA was common, and there is also speculation that a future release of Oracle will reconfigure itself based on the needs of the database. 

However, until then, changing the SGA requires constant monitoring, and it is sometimes a good approach to develop a general setting for the SGA parameters based on the historical needs of the application.


Get the Complete
Oracle Tuning Details 

The landmark book "Oracle Tuning: The Definitive Reference Second Edition" has been updated with over 1,150 pages of expert performance tuning tips. It's packed with scripts and tools to hypercharge Oracle 11g performance and you can buy it for 40% off directly from the publisher.


Download your Oracle scripts now:

The definitive Oracle Script collection for every Oracle professional DBA


Oracle performance tuning software 

Oracle performance tuning book


Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel
Oracle training & performance tuning books

Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.