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
Explain about achiever in sql?
What is logical backup in oracle?
What are the different oracle database objects?
How many types of auditing in Oracle?
In what script is snap$ created? In what script is the scott/tiger schema created?
What is a proxy object?
How to create a stored program unit?
What are the types of partitions in oracle?
How to compare dates in oracle sql?
defination of bitmap index
What is bulk copy or bcp in oracle?
What is oracle update statement with inner join ?
What is an index associated with a constraint?
Can we call procedure inside function in oracle?
How to import one table back from a dump file?