Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors causing the reparsing of SQL statements
in SGA?
- 2 Answers
- 5443 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 |
How to use fetch statement in a loop?
List the parts of a database trigger.
what diffrence between function and procedure?
What is the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN?
Why do you use stored procedures and state some of its disadvantages?
What is the order of defining local variables and sub procedures/functions?
It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
What are the common oracle dba tasks?
Explain the use of constraints option in exp command.
How to use "while" statements in oracle?
Explain user account with reference to oracle.
What is the database name in oracle?
Oracle General 
