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-33223: (CMOVE03) You cannot move a session-only dimension value.

1 Answers  


LSX-00290: invalid enumeration choice "~S"

1 Answers  


ORA-32636: Too many rules in MODEL

1 Answers  


ORA-14074: partition bound must collate higher than that of the last partition

1 Answers  


ORA-24082: propagation may still be happening for the schedule for QUEUE string and DESTINATION string

1 Answers  


DRG-51024: out of memory in stemmer

1 Answers  


TNS-00244: Connection Manager: Request Failed

1 Answers  


ORA-14188: sub-partitioning columns must form a subset of key columns of a UNIQUE index

1 Answers  


DRG-50861: failed to obtain type descriptor

1 Answers  


ORA-06743: TLI Driver: cannot alloc t_bind

1 Answers  


ORA-09951: Unable to create file

1 Answers  


ORA-22933: cannot change object with type or table dependents

1 Answers  


Categories