<<Previous Next>>
Oracle - What is Program
Global Area (PGA)? - Feb 07, 2010 at 14:20 PM by Shuchi
Gauri
What is Program Global Area
(PGA)?
The Program Global Area (PGA): stores data and
control information for a server process in the memory. The PGA
consists of a private SQL area and the session
memory.
Oracle - What
is Program Global Area (PGA)? - April 10, 2009 at 11:00
AM
What is Program Global Area
(PGA)?
The PGA is a memory area that contains data
and control information for the Oracle server processes. This area
consists of the following components:
Stack space--This holds the session's variables and arrays.
Session information--If you are not running the multithreaded
server, the session information is stored in the PGA. If you are
running the multithreaded server, the session
Private SQL area--This area keeps information
about binding variables and runtime buffers.
Also read
How do you increase the performance of %LIKE operator?, What is a
standby database? Difference between Physical and logical standby
databases, What is Cache Fusion Technology?, What is simple
replication and advance replication?.............
A cold backup is done when there is no user activity going on
with the system. Also called as offline backup, is taken when the
database is not running and no users are logged in........
Automatic Performance Diagnostic and Tuning Features, Automatic
Shared Memory Management - Automatic Shared Memory Management
puts Oracle in control of allocating memory within
the SGA...........
| 
