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


 

HTML Text

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:

www.oracle-script.com

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.