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-12232: TNS:No path available to destination

1 Answers  


ORA-08235: smsget: listener not on this node

1 Answers  


EXP-00006: internal inconsistency error

1 Answers  


ORA-09700: sclin: maximum number of latches exceeded

1 Answers  


ORA-00367: checksum error in log file header

1 Answers  






ORA-25296: Queue Table string has a buffered queue string

1 Answers  


RMAN-20201: datafile not found in the recovery catalog

1 Answers  


NNL-00047: LDAP modify returned error: 0xnumber, string

1 Answers  


ORA-12609: TNS: Receive timeout occurred

1 Answers  


ORA-09792: sllfop: cannot allocate read buffer.

1 Answers  


LPX-00018: internal error "nested open strings"

1 Answers  


PLS-00920: parameter plsql_native_library_dir is not set

1 Answers  


Categories