ORA-04032: pga_aggregate_target must be set before switching to auto mode

admin

ORA-04032:pga_aggregate_target must be set before switching to auto mode
Cause: attempt to set workarea_size_policy to AUTO whilepga_aggregate_target
is not specified
Action: beforesetting workarea_size_policy, set pga_aggregate_target to a value
representing the total private memory available to the instance. This total is
generally the total physical memory available in the system minus what isneeded
for the SGA minus what is needed for the operating system (e.g. 500MB)