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

PLS-00651: implementation type in Aggregate/Table function should be a valid type

1 Answers  


DRG-11824: Method Not Allowed

1 Answers  


ORA-14616: table is not subpartitioned by List method

1 Answers  


ORA-28108: circular security policies detected

1 Answers  


NNL-00203: Scheduled shutdown to occur in string

1 Answers  






ORA-26577: PRESERVE TABLE can not be used when dropping old style materialized view string.string

1 Answers  


UDE-00050: Unable to setup parameter processing.

1 Answers  


TNS-12511: TNS:service handler found but it is not accepting connections

1 Answers  


ORA-02298: cannot validate (string.string) - parent keys not found

2 Answers  


SQL*Loader-00276: Local storage option overrides global storage.

1 Answers  


ORA-26507: null master connection

1 Answers  


ORA-02058: no prepared transaction found with ID string

1 Answers  


Categories