Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors causing the reparsing of SQL statements
in SGA?
- 2 Answers
- 5523 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 |
Explain the difference between a procedure and a function?
How to convert times to characters in oracle?
Explain index?
how do we code triggers , store procedure , Performance tuning and indexing in a Java Project? Pls kindly get me the perfect answer with the code for each....thank you in advance............pls any body kindly help me soon as possible....
What are the differences between number and binary_float in oracle?
Can you tell me how to add new column in existing views?how?How is possible?
How can I combine multiple rows into a comma-delimited list in oracle?
What is meant by recursive hints ?
What are the various constraints used in oracle?
What does ROLLBACK do ?
1.display list of all users from ur data base.what is the query?
Is oracle a relational database?
Oracle General 
