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

LPX-00302: Incorrect stylesheet. The node is not valid.

1 Answers  


ORA-00113: protocol name string is too long

1 Answers  


NMP-00006: uninitialized SNMP context

1 Answers  


KUP-03015: OCI error getting datetime lfprecision.

1 Answers  


ORA-37018: (XSACQUIRE03) Multiwriter operations are not supported for object workspace object.

1 Answers  


IMG-00842: image index allocation failed

1 Answers  


RMAN-08046: channel string: starting compressed full datafile backupset

1 Answers  


ORA-07223: slspool: fork error, unable to spawn spool process.

1 Answers  


ORA-12480: specified clearance labels not within the effective clearance

1 Answers  


LCD-00113: integer conversion error or negative integer [string]

1 Answers  


ORA-07489: scgrcl: cannot get lock status.

1 Answers  


DRG-10204: server update failed

1 Answers  


Categories