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

Explain what are the type of synonyms?

1105

 What are the oracle DML commands possible through an update strategy?

1059

How many categories of data types in oracle?

1026

Explain the blob datatype?

1071

How to define an anonymous procedure without variables?

1095

What is an external table?

1013

How does one get the view definition of fixed views/tables?

1017

How do I learn what codesets are available in oracle?

1036

How to update values in a table in oracle?

1011

How different is ms access and oracle?

1034

What are the differences between char and varchar2 in oracle?

1164

Why should I use oracle database?

984

What is the usage of save points in oracle database?

962

What is transport network substrate (tns) in oracle?

1041

Explain parameter file in oracle.

1022