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 ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the simplest tool to run commands on oracle servers?
What is index in Oracle?
What is an external table?
How do I connect to oracle database?
How to pass parameters to procedures?
Explain the use of record option in exp command.
Hi Can any one tell me what are the API's used in requisition import.
How to resolve name conflicts between variables and columns?
What is a nested table?
What is a partition in oracle?
How to delete an existing row from a table in oracle?
How to store pictures on to the database?
What is a read write transaction in oracle?
Explain integrity constraints?
What is redo log?