PGA :
consist of
1. private sql area ;
The private SQL area of a cursor is divided into two areas :
a. Persistent area ;
b. Run-time area ;
2. Session Memory ;
For a shared server environment, the session memory is shared and not private
3. SQL work areas ;
WORKAREA_SIZE_POLICY = AUTO ;
PGA_AGGREGATE_TARGET =189792256
SORT_AREA_SIZE, HASH_AREA_SIZE,
BITMAP_MERGE_AREA_SIZE, CREATE_BITMAP_AREA_SIZE
Memory Area | Dedicated Server | Shared Server |
Nature of Session Memory | Private | Shared |
Location of Persistent Area | PGA | SGA |
Location of Run-time Area (SELECT) | PGA | SGA |
Location of Run-time Area (DML/DDL) | PGA | PGA |