pga_aggregate_target
is not set to 0, Oracle sets it to the greater value of 20% of the size of the SGA or 10 MB. workarea_size_policy
is automatically set to auto
. pga_aggregate_target
to the following percentage of the memory available to Oracle (i. e. memory not used by the OS and non-Oracle processes):