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
How oracle handles dead locks?
Why packages are used in oracle?
What are the execution control statements in oracle?
What is null value in oracle?
How would you begin to troubleshoot an ORA-3113 error?
What is primefaces used for?
What is oracle rownum?
How do I manually uninstall oracle client?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
What is a tns file?
What are dml statements in oracle?
What are the oracle built-in data types?
what is the dual table in oracle?
Is the After report trigger fired if the report execution fails ?