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

What are the four objectives of the selection of a data type?

960


What is computer end?

969


What is the function of DML Compiler?

1278


Is dynamodb a document database?

995


What do you mean by checkpoints in dbms?

921


Which database is best for large data?

1056


Which is the best free database software?

995


In which format image is stored in database?

949


What integrity rules exist in the dbms?

1077


What are the disadvantages of a query?

1094


Is sql a database?

977


What is a checkpoint and When does it occur in database?

1148


How to debug stored procedures?

1025


How do you create a report in a database?

927


Explain ddl interpreter?

1263