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

I've got a database (Oracle Database 10g Enterprise Edition Release 10.2.0.2.0) installed on a server. Via the network I try to connect to the database via a frontend DEVELOPER 2000 R 2.1 (SQL*Plus: Release 3.3.4.0.0 ) while connecting to database I've got the following error- message: ORA-12637: Packet receive failed

2 Answers  


ORA-13366: invalid combination of interior exterior rings

1 Answers  


ORA-07750: slemcr: fopen failure

1 Answers  


ORA-13433: GeoRaster metadata default RGB error

1 Answers  


ORA-24440: OCI Easy Install mode cannot be initialized

1 Answers  


ORA-15023: reached maximum allowable number of disks string

1 Answers  


ORA-31122: The string operator has incorrect RHS value

1 Answers  


SQL-02141: Collection descriptor has not been allocated

1 Answers  


IMG-00603: unable to access source image data

1 Answers  


QSM-01006: query rewrite disabled for this query block

1 Answers  


ORA-40221: maximum target cardinality exceeded

1 Answers  


ORA-02443: Cannot drop constraint - nonexistent constraint

1 Answers  


Categories