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 / 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 the use of online redo log files in oracle.

1038


What is an oracle wallet?

942


Hi friends can u send the oracle 9i full version download link?????????????? please reply ?

1865


In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

4174


Explain the use of record length option in exp command.

1067


What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.

1109


How to execute a stored program unit?

1079


Can we write insert statement in function in oracle?

1095


How to use existing values in update statements using oracle?

1069


What are the tools for Oracle ?

1066


What is a relational database management system?

1121


how the indexes are stored in the Oracle Database?

2271


How to create a table index in oracle?

1134


State the difference between a primary key and foreign key?

937


How to build data dictionary view an new database?

1012