Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors causing the reparsing of SQL statements
in SGA?
- 2 Answers
- 5516 Views
- I also Faced
- E-Mail Answers
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 an oracle user account?
What is the implicit cursor in oracle?
what is difference between sql plus and sql*plus? (not sql and sql plus).
What are the extensions used by oracle reports?
what is the difference between data migration and production migration.
What is the difference between pre-select and pre-query?
What is set verify off in oracle?
What are the original export and import utilities?
ABOUT IDENTITY?
Which is better Oracle or MS SQL? Why?
What are temporal data types in oracle?
What are the predefined tablespaces in a database?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
How to use "while" statements in oracle?
How do we get field details of a table?
