Oracle Database 10G - Automatic Sga Memory Management

Oracle Database 10G - Automatic Sga Memory Management - The...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
The Self-Managing Database: Automatic SGA Memory Management An Oracle White Paper Nov. 2003
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
The Self-Managing Database: Automatic SGA Memory Management Introduction. .......................................................................................... 3 Current Challenges . .............................................................................. 3 Introducing Automatic Shared Memory Management . ........................ 4 The SGA_TARGET Parameter . ....................................................... 4 Automatically Managed SGA Components. ..................................... 4 Manually Sized SGA Components. .................................................. 7 Benefits . ................................................................................................ 8 More Flexible and Adaptive Memory Utilization . ........................... 8 Enhanced Performance . .................................................................... 9 Ease of Use . ...................................................................................... 9 Enabling Automatic Shared Memory Management . ............................ 9 Dynamic Modification of SGA Parameters. ....................................... 11 Dynamic Modification of SGA_TARGET. .................................... 11 Dynamic Modification of Parameters for Automatically Managed Components . ................................................................................... 12 Modification of Parameters for Manually Sized Components . ...... 13 Persistence of Auto Tuned Values. ..................................................... 13 Conclusions. ........................................................................................ 13 The Self-Managing Database: Automatic SGA Memory Management Page 2
Background image of page 2
The Self-Managing Database: Automatic SGA Memory Management INTRODUCTION One of the key self-management enhancements in the Oracle Database 10g is Automatic Shared (SGA) Memory Management. This functionality automates the management of shared memory used by an Oracle Database 10g instance and liberates administrators from having to manually configure the sizes of shared memory components. Besides making more effective use of available memory and thereby reducing the cost incurred of acquiring additional hardware memory resources, the Automatic Shared Memory Management feature will significantly simply Oracle database administration by introducing a more dynamic, flexible and adaptive memory management scheme. This paper introduces this functionality and illustrates its advantages. CURRENT CHALLENGES The Shared Global Area (SGA) in Oracle comprises multiple memory components -- a component being a pool of memory used to satisfy a particular class of memory allocation requests. Examples of memory components include the shared pool (used for allocating memory for SQL and PL/SQL execution), java pool (used for java objects and other java execution memory), buffer cache (used for caching disk blocks), etc. In past releases, the Oracle administrator was required to manually set a number
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/21/2009 for the course CS 267 taught by Professor Butt,f during the Spring '08 term at San Jose State University .

Page1 / 14

Oracle Database 10G - Automatic Sga Memory Management - The...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online