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

  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

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

Question Posted / nishi

Answer Posted / nishi

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 ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we convert a date to char in oracle and if so, what would be the syntax?

957

What are the built-in functions used for sending Parameters to forms ?

3308

What is a subquery?

1057

what are archived logs?

2142

How to rename a tablespace in oracle?

1033

What is the difference between a hot backup and a cold backup in oracle?

957

Explain the use of file option in exp command.

1079

How different is ms access and oracle?

987

What is a schema in oracle?

966

What is the usage of save points in oracle database?

907

How to define an external table with a text file?

1019

Explain do view contain data?

940

What is a system tablespace and when it is created?

918

Can you have more than one content canvas view attached with a window ?

2261

What is the quickest way to export a table to a flat file?

918