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 |
NNL-00897: Messages sent: number
TNS-12554: TNS:current operation is still in progress
TNS-00530: Protocol adapter error
ORA-19571: %s recid string stamp string not found in controlfile
ORA-26519: no memory available to allocate
LFI-00100: Unable to perform operation, file not opened in string.
ORA-01342: LogMiner can not resume session due to inability of staging checkpointed data
ORA-32831: timed out trying to acquire administration lock
ORA-14050: invalid ALTER INDEX MODIFY PARTITION option
ORA-25449: invalid variable name: string
ORA-02819: Write failed
PLS-00484: redundant exceptions 'string' and 'string' must appear in same exception handler