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

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

In the oracle version 9.3.0.5.0, what does each number shows?

1249


I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.

2282


Can we store images in oracle database?

959


How much memory your 10g xe server is using?

1069


Give syntax for SQL and ORACLE joins.

1069


Explain alias?

1098


How to run queries on external tables?

1001


What is a snapshot log?

967


How to connect to oracle using service name instead of sid?

972


Can group functions be used in the order by clause in oracle?

954


Why does oracle 9i treat an empty string as null?

1000


List out the components of logical database structure of oracle database.

1004


What are transaction isolation levels supported by oracle?

1021


What is null value in oracle?

1058


How do I uninstall oracle client from windows?

979