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...

What are the factors causing the reparsing of SQL statements
in SGA?

Answer Posted / sawant

Due to insufficient Shared SQL pool size.

Monitor the ratio of the reloads takes place while
executing SQL statements. If the ratio is
greater than 1 then increase the SHARED_POOL_SIZE.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the simplest tool to run commands on oracle servers?

971


What is index in Oracle?

1030


What is an external table?

975


How do I connect to oracle database?

1047


How to pass parameters to procedures?

993


Explain the use of record option in exp command.

957


Hi Can any one tell me what are the API's used in requisition import.

1892


How to resolve name conflicts between variables and columns?

995


What is a nested table?

1023


What is a partition in oracle?

1061


How to delete an existing row from a table in oracle?

1033


How to store pictures on to the database?

934


What is a read write transaction in oracle?

1053


Explain integrity constraints?

1074


What is redo log?

1019