What are the factors causing the reparsing of SQL statements
in SGA?
- 2 Answers
- 4795 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 would you begin to troubleshoot an ORA-3113 error?
What are temporal data types in oracle?
What is bulk load in oracle?
What is the exact use of Collections?
What is the maximum limit on the number of columns in a table?
Why use resource manager in Oracle?
find the second highest salary of the emp table
what is the difference between substr and instr function in oracle?
What are the major difference between truncate and delete?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
how to retrive xml data for using sql query?
Define 'view' advantage ?
Oracle General 
