ORACLE PGA

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