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-09975: kxfspini: Error Initializing SDI Process

1 Answers  


IMG-00921: threshold out of range

1 Answers  


PLS-01704: The expressions in a sort clause must be column specs or unsigned integers, with optional ASC or DESC

1 Answers  


RMAN-06437: cannot drop catalog - catalog is newer than this RMAN

1 Answers  


O2F-00326: Some characters in this name were not legal identifier characters

1 Answers  


RMAN-06093: recovery catalog contains obsolete version of datafile string

1 Answers  


PCC-01013: Invalid use of PIC N array variable "string" at line number in file string

1 Answers  


ORA-09960: Unable to establish signal handler for termination signal

1 Answers  


ORA-14057: partition "string": sum of PCTUSED and PCTFREE may not exceed 100

1 Answers  


ORA-01771: illegal option for a clustered table

1 Answers  


TNS-00081: * trace_on - ask process name to turn tracing on

1 Answers  


ORA-27003: cannot open file on device allocated with NOIO option

1 Answers  


Categories