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 |
Define oracle database
What is meant by raw datatype?
How remove data files before opening a database?
Explain what are synonyms used for?
In Oracle 10g, "g" Stands for what?
what is data abstraction
how to get the second max val for every group in a table
How many types of auditing in Oracle?
What is the difference between post-database commit and post-form commit?
6. Display the client name and order date for all orders using the traditional method.
How to get a list of all background sessions in the database?
Explain what does a control file contain?