Parameters Affecting Memory Usage

The memory required by any one Oracle session depends on many factors.
Typically the major contributing factors are:

■ Number of open cursors
■ Memory used by PL/SQL, such as PL/SQL tables
■ SORT_AREA_SIZE initialization parameter

In Oracle, the PGA_AGGREGATE_TARGET initialization parameter gives greater control
over a session's memory usage.