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

LSX-00232: invalid unsigned long "~S"

1 Answers  


PLS-00387: INTO variable cannot be a database object

1 Answers  


ORA-02216: tablespace name expected

2 Answers  


ORA-13278: failure to convert SRID to native format

1 Answers  


PLS-00312: a positional parameter association may not follow a named association

1 Answers  






ORA-24010: QUEUE string does not exist

1 Answers  


PCB-00628: Buffer type is incompatible with LOB type

1 Answers  


RMAN-06513: copy will never be obsolete

1 Answers  


TNS-00504: Operation not supported

1 Answers  


NNL-00558: set|show namesctl_trace_level : set|show the controller's tracing level

1 Answers  


NMP-00005: general SNMP error

1 Answers  


ORA-24183: invalid transformation

1 Answers  


Categories