Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors causing the reparsing of SQL statements
in SGA?
- 2 Answers
- 5332 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 |
State and explain about oracle instance?
What is blob datatype?
what is the difference between restoring and recovering?
What different of iner joint & outer joint with example
Explain an integrity constrains?
Please explan Why static query is more faster than dynamic query ?
How different is ms access and oracle?
What are the set operators union, union all, minus & intersect meant to do?
In oracle there is column command, how will you explain that?
What is the effect of setting the 'RULE' for OPTIMIER_GOAL parameter of the ALTER SESSION Command ?
pls explain connect by prior with example and its real time use
How does Oracle guarantee data integrity of data changes?
Oracle General 
