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 >> Database Management
  2. Suggest New Category

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

Question Posted / guest

Answer Posted / guest

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

Define sub-query.

978

How to disconnect the user connection?

840

What is an image database?

882

What is a candidate key in a database?

848

What is normalization and why it is used?

1077

Explain the hierarchical database?

977

What do you mean by Checkbox ?

2424

What are 3 types of databases?

929

Describe the differences between vertical and horizontal portioning.

984

Is sql a database?

893

What is db driver?

892

How to detect applications and users that hold transactions open too long?

863

What is dbms language?

895

What is meant by database management system?

998

What is data sublanguage?

992