What are the factors causing the reparsing of SQL statements
in SGA?
- 1 Answers
- 4045 Views
- I also Faced
- E-Mail Answers
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 |
Are truncate and delete commands same? If so why?
Is oracle a relational database?
what is primary key and foreign key when and where have to use
What is OCI. What are its uses?
How to create index-by table in oracle?
What is the database name in oracle?
What is the CAP theorem?
what is main def between plsql/table and array?
what is analyze command ? what kind of statistics does it generate?
What is Index Cluster ?
What is Public Database Link ?
How to use "if" statements on multiple conditions?
Oracle General 
