Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors causing the reparsing of SQL statements
in SGA?
- 2 Answers
- 5521 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 ? | 1 Yes | 0 No |
Answer / 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 |
What is oracle join syntax?
What is a tns file?
Can objects of the same Schema reside in different tablespaces.?
what are the advantages of running a database in NO archive log mode?
How to start your 10g xe server?
how to create a new database in oracle?
How do you rate yourself in oracle and sql server ?
Briefly explain what is literal? Give an example where it can be used?
Table1- have two column filename data AFGDFD-20112011 hi how r u bsdasd-23042011 name shoud be in bold Now i want output like filename data AFGDFD hi how r u bsdasd name shoud be in bold Kindly answer this
Is oracle a relational database?
What is an oracle transaction?
Can we convert a date to char in oracle and if so, what would be the syntax?
Oracle General 
