Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

NNL-00897: Messages sent: number

1 Answers  


TNS-12554: TNS:current operation is still in progress

1 Answers  


TNS-00530: Protocol adapter error

1 Answers  


ORA-19571: %s recid string stamp string not found in controlfile

1 Answers  


ORA-26519: no memory available to allocate

1 Answers  


LFI-00100: Unable to perform operation, file not opened in string.

1 Answers  


ORA-01342: LogMiner can not resume session due to inability of staging checkpointed data

1 Answers  


ORA-32831: timed out trying to acquire administration lock

1 Answers  


ORA-14050: invalid ALTER INDEX MODIFY PARTITION option

1 Answers  


ORA-25449: invalid variable name: string

1 Answers  


ORA-02819: Write failed

1 Answers  


PLS-00484: redundant exceptions 'string' and 'string' must appear in same exception handler

1 Answers  


Categories