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

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

How to load excel data sheet to oracle database

1079

Write a syntax for update query in oracle?

1076

How to export your connection information to a file?

1177

How to use "startup" command to start default instance?

1102

How many types of auditing in Oracle?

1088

List out the types of joins.

1241

What is dynamic proxy?

1054

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4685

Give the various exception types.

1040

What are the different types of record groups in oracle? Explain each of them

1073

What is format trigger?

2121

What are transaction isolation levels supported by oracle?

1117

How to convert a string to a date in oracle database?

1102

What are the limitations of check constraint?

1076

How do I use os authentication with weblogic jdriver for oracle and connection pools?

1099