What are the factors causing the reparsing of SQL statements
in SGA?
- 2 Answers
- 4530 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 features of oracle?
How to view all columns in an existing table?
What is a recycle bin in oracle?
What is a system tablespace and when it is created?
sql command 2 know current database
What is Hash Index?
How to create a new table in your schema?
What are the different pseudo commands? Explain in general?
cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..
How to sort output in descending order in oracle?
How to invoke the data pump import utility?
How to convert characters to dates in oracle?
Oracle General 
