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 / sawant

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to add a new column to an existing table with a default value?

1019

How to connect to a remote server?

1132

Is it possible to split the print reviewer into more than one region ?

2282

What is program global area (pga) in oracle?

1037

Explain the dml?

990

Explain the difference between sql and oracle?

1088

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

2263

Difference between inner join vs where ?

1047

What is transport network substrate (tns) in oracle?

1049

How will you identify oracle database software release?

1018

What is the difference between substr and instr?

1042

What is blob datatype?

1134

Use of an integrity constraint is better to validate data. Explain

1046

Explain index?

1267

Differentiate between post-database commit and post-form commit?

1049