What are the factors causing the reparsing of SQL statements
in SGA?
- 2 Answers
- 4531 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain what are the characteristics of data files?
Explain temporal data types in oracle
What do you mean by group by clause?
what is the use of system.effective.date variable in oracle?
How to join two tables in a single query using oracle?
Can you assign multiple query result rows to a variable?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
Explain the characteristics of oracle dba?
What is the data type of dual table?
How to rebuild an index in oracle?
What is the order of defining local variables and sub procedures/functions?
What privilege is needed for a user to create views in oracle?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
How to generate query output in html format?
Explain a private synonyms?
