What are the factors causing the reparsing of SQL statements
in SGA?
- 2 Answers
- 4349 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 |
What is a initialization parameter file in oracle?
What is Private Database Link ?
What is the difference between an Oracle Schema and an Oracle Instance?
How to rename a column in an existing table?
how to hide the stored procedure inside a package
How to execute the package in oracle?
Describe varray?
How to drop an existing table in oracle?
How a tablespace is related to data files?
Can we write insert statement in function in oracle?
Explain what are the different type of segments?
Explain the characteristics of oracle dba?
Oracle General 
