WORKAREA_SIZE_POLICY specifies the policy for sizing work areas. This parameter controls the mode in which working areas are tuned.
Work areas used by memory-intensive operators are sized automatically, based on the PGA memory used by the system, the target PGA memory set in
PGA_AGGREGATE_TARGET, and the requirement of each individual operator.
The sizing of work areas is manual and based on the values of the *
_AREA_SIZE parameter corresponding to the operation (for example, a sort uses
MANUAL may result in sub-optimal performance and poor PGA memory utilization.