1. Administrator's Guide
  2. Optimizing Performance
  3. Tuning Oracle 11g Databases for Financial Management
  4. Tuning Guidelines for Oracle 11g Databases
  5. PGA_AGGREGATE_TARGET

PGA_AGGREGATE_TARGET

PGA_AGGREGATE_TARGET specifies the total PGA memory available to all server processes attached to the instance. If Automatic Memory Management is enabled, and PGA_AGGREGATE_TARGET is set to a non-zero value, then this value serves as the minimum size of PGA.

Suggested setting: 0 if Automatic Memory Management is enabled; otherwise refer to How to Determine Memory Settings for Oracle Database Release 11g.