Name
WORKAREA_SIZE_POLICY
Synopsis
Value: AUTO | MANUAL
Default: derived
Dynamic: ALTER SYSTEM, ALTER SESSION
Specifies the policy for sizing work areas. If AUTO, work areas used by memory-intensive operations are sized automatically, based on the PGA memory used by the system. This value can be specified only if PGA_AGGREGATE_TARGET is defined and is the default if PGA_AGGREGATE_TARGET is defined. If MANUAL, the sizing of work areas is manual and is based on the value of the corresponding *_AREA_SIZE parameter that applies (e.g., a sort uses SORT_AREA_SIZE) to the operation being performed. MANUAL is the default if PGA_AGGREGATE_TARGET is not defined. Obsolete with Oracle9i.