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

Is there an example how to configure externalfileaccess setting in firebird.conf?

962


What is db flush?

905


Give us a non-computer example of preemptive and non-preemptive scheduling?

924


What is db driver?

964


What are the types of rdbms?

900


What is normalisation and its type?

938


Can I use google sheets as a database?

978


Why is group-clause used?

955


What is system r? How many of its two major subsystems?

1016


What is second normal form?

933


What do you understand by ‘atomicity’ and ‘aggregation’?

906


What is normal form in dbms?

911


Explain the advantages and disadvantages of a hierarchical database?

1064


Which is fastest database?

908


How to repair a corrupt firebird database?

1069