Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors causing the reparsing of SQL statements
in SGA?
- 1 Answers
- 4389 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 ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can you merge two tables in oracle?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
How to drop an index in oracle?
How to invoke the data pump export utility?
Explain joins in oracle?
What do you mean by merge in oracle and how can you merge two tables?
What is the difference between a user and a schema in oracle?
How to initialize variables with default values?
What is tns service name?
What are the different types of failures that occur in Oracle database?
What is difference between sid and service name in oracle?
How to load a large xml file?
What is ADDM Advisor in Oracle?
What is a parameter file in oracle?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
