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



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

Answer / guest

Cause: attempt to set workarea_size_policy to AUTO while
pga_aggregate_target is not specified

Action: before setting 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 is needed for the SGA minus what is needed for
the operating system (e.g. 500MB)

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-25461: rule set not specified

1 Answers  


ORA-31490: could not attach to LogMiner session

1 Answers  


ORA-00066: LOG_FILES is string but needs to be string to be compatible

1 Answers  


TNS-00103: Parameter file load error

1 Answers  


RMAN-08039: channel string: starting incremental datafile backupset restore

1 Answers  


ORA-22059: buffer size [string] is too small - [string] is needed

1 Answers  


ORA-16516: The current state is invalid for the attempted operation.

1 Answers  


QSM-01038: logical operator(s) could not be processed

1 Answers  


IMG-00556: incorrect number of gamma values

1 Answers  


ORA-02880: smpini: Could not register PGA for protection

1 Answers  


NNO-00074: downloading region from server string

1 Answers  


ORA-38774: cannot disable media recovery - flashback database is enabled

1 Answers  


Categories