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

ORA-12020: materialized view string is not registered

1 Answers  


PLS-00218: a variable declared NOT NULL must have an initialization assignment

1 Answers  


ORA-02091: transaction rolled back

1 Answers  


ORA-13041: failed to compare tile with element string.string.string

1 Answers  


ORA-02830: Segment could not be split - no free segments available

1 Answers  


ORA-13401: duplicate entry for string in USER_SDO_GEOR_SYSDATA view

1 Answers  


LSX-00258: invalid escape character

1 Answers  


ORA-02846: Unkillable server

1 Answers  


ORA-09830: snyAddPort: failed to perform a remote procedure call.

1 Answers  


ORA-06902: CMX: cannot attach to cmx subsystem

1 Answers  


ORA-00303: cannot process Parallel Redo

1 Answers  


RMAN-02000: wrong message file version (msg number not found)

1 Answers  


Categories