What are the factors causing the reparsing of SQL statements
in SGA?
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 are archived logs?
What is the difference between a hot backup and a cold backup in oracle?
What is a cluster Key ?
What happens to indexes if you drop a table?
How to rename a tablespace in oracle?
How to turn on or off recycle bin for the instance?
How to create a new table by selecting rows from another table?
How to write date and time literals in oracle?
What are the system predefined user roles?
What are the ways tablespaces can be managed and how do they differ?
Explain the use of grant option in exp command.
How to assign data of the deleted row to variables?