Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors causing the reparsing of SQL statements
in SGA?
- 2 Answers
- 5290 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 ? | 1 Yes | 0 No |
Answer / 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 |
Which is better Oracle or MS SQL? Why?
how to we delete a row using varray
how to find find & delete duplicate rows from two different tables?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
why pl sql doesn't support retrieving multiple records
If server is in US and client is in india there is timezone is diffrence, How can we display date in indian time when data is displayed from US server timezone?
Explain user account with reference to oracle.
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How would you extract DDL of a table without using a GUI tool?
What is connection pooling in oracle?
What is recovery manager(rman) backup in Oracle?
emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
Oracle General 
