Oracle Database Memory Structures

Oracle Database creates and uses memory structures for various purposes. For example, memory
Stores program code being run, data, was shared among users, and private data areas for each
Connected user.
Both basic memory structures is associated with an instance:
•System Global Area (SGA): Group of shared memory structures, known as SGA
components, which contain Dataand control information for one Oracle Database instance.
The SGA is a shared by all server and background processes. Examples of data stored in the
SGA include cached data blocks and shared SQL areas.
•Program Global Areas (PGA): Memory regions that contain data and control information
For a server or background process. A PGA is nonshared memory created by Oracle
Database when the a server or background process is started. Access to the PGA is exclusive
to the server process. Each server process and background process have its own PGA

The SGA is the memory area Thatcontains data and control information for the instance. The
SGA includes the following data structures:
•Shared Pool: Caches various constructs that can be shared among users
•Database Buffer Cache: Caches blocks of data retrieved from the database
•KEEP Buffer Pool: A Specialized type of database buffer cache that's tuned to retain
Blocks of data in memoryfor long periods of time
•RECYCLE Buffer Pool: A Specialized type of database buffer cache that was tuned to
Recycle or remove block from memory quickly
•NK Buffer Cache: One of several specialized database buffer caches designed to hold
Block sizes different than the default database block size
•Redo Log Buffer: Caches Redo information (used for instance recovery) until it can
Written to the physical redo log files stored on the disk
•Large Pool: Optional area, provides large memory allocations for certain large
Processes, such as Oracle backup and recovery operations, and I/O server processes
•Java Pool: Used for all session-specific Java code and data in the Java Virtual machine
(JVM)
•Streams Pool: Used by the Oracle Streams to store information required by capture and apply
When you start the instance by using Enterprise Manager or Sql*plus, the amount of memory
Allocated for the SGA is displayed.
A Program Global Area (PGA) Isa memory region, that containsdata and control information
For each server process. An Oracle server process services A client ' s requests. Each server
Process has it own private PGA that was allocated when the server process is started. Access to
The PGA is exclusive to that server process, and the PGA are read and written only by the Oracle
Code acting on its behalf. The PGA is divided to major areas:stack space and the user
Global Area (UGA).
With the dynamic SGA infrastructure, the sizes ofthe database buffer cache, the shared pool, the
Large pool, the Java pool, and the Streams pool can change without shutting down the instance.
The Oracle database uses initialization Parametersto Create and manage memory structures. The
Simplest-manage memory isto allow the database to automatically manage and tune it for
You. To doing so (on the most platforms), you are only having to set a target memory size initialization
Parameter (memory_target) and a maximum MEMORY size initialization parameter
(Memory_max_target).

Oracle Database Memory Structures