|
<<Previous Next>>
Oracle -
Explain oracle memory structures. - April 10, 2009 at
11:00 AM
Explain oracle memory
structures.
Two memory area.
System global area(SGA)
Program Global Area(PGA)
SGA consist memory structure such as
Shared Pool
Database
buffer cache
Redo log buffer
large Pool
Java Pool
Oracle - Explain oracle memory
structures. - June 18, 2009 at 19:00 PM
We have two memory areas that comprise the memory structure of
oracle.
System Global Area(SGA) : It is also called as
Shared Global Area. It stores data and control information for the
oracle server and can be shared by database processes.
Program Global Area(PGA) : It is also called as
Process Global Area. It contains data and control information for a
single server process.
Following are the structure contained in the SGA:
Shared pool: It stores most recently executed
statements.
Database buffer cache: It stores
copies of data block.
Redo log buffer: It
records all changes made to the database blocks.
Large
pool: It is optional area of the memory that can be used by
the shared pool in order to relieve load on it.
Java
pool: This area is used for parsing java command.
Also read
Describe Oracle architecture in brief, What is the function of
SMON?, Explain different types of segment, Explain SGA memory
structures..............
Automatic Performance Diagnostic and Tuning Features, Automatic
Shared Memory Management - Automatic Shared Memory Management puts
Oracle in control of allocating memory within the SGA..........
Software area code: - It is a protected location that is used to
store oracle code that is supposed to be run. The location is
different from users' programs. The software area code is read only
and can be shared or nonshared...............
The PGA is a memory area that contains data and control
information for the Oracle server processes. This area consists of
the following components:.............
It is the area in SGA that allows sharing of parsed SQL statements among concurrent users............
| 
