What are the factors causing the reparsing of SQL statements
in SGA?
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 ? | 0 Yes | 0 No |
where do i find oracle interview questions.
how to get the second max val for every group in a table
What is an Index ?
What is oracle database 10g express edition?
Explain what are synonyms used for?
Give the advantages and disadvantages of clusters.
Is it possible to disable the parameter from while running the report ?
How can you merge two tables in oracle?
What is the max number of columns in an oracle table?
primary key is foreign key for the same table?
Explain the family trees and connection by clause
What is the difference between Outer join and Full outer join?