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

IMG-00602: unable to access image data

1 Answers  


ORA-12164: TNS:Sqlnet.fdf file not present

1 Answers  


ORA-06802: TLI Driver: could not open the /etc/netware/yellowpages file

1 Answers  


ORA-07615: $CHANGE_CLASS failed in retrieving the specified file label

1 Answers  


ORA-24049: invalid agent name string, names with AQ$_ prefix are not valid

1 Answers  


PCB-00550: Unable to log on to ORACLE with "string". ORACLE error number: number

1 Answers  


SQL*Loader-00560: error reading file

1 Answers  


ORA-13851: Tracing for client identifier string is already enabled

1 Answers  


ORA-29326: SET COMPATIBILITY release number higher than string

1 Answers  


ORA-27014: skgfqpini: translation error while expanding SS_UDMPDIR

1 Answers  


QSM-01043: join back attempted on a table to the RHS of a semi or anti join for string

1 Answers  


ORA-28137: Invalid FGA audit Handler

1 Answers  


Categories