Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors causing the reparsing of SQL statements
in SGA?
- 2 Answers
- 5421 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 |
How to rollback the current transaction in oracle?
How to define a variable of a specific record type?
what is a view?
What are the various constraints used in oracle?
How can we view last record added to a table?
Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??
What are the system predefined user roles?
The join defined by the default data link is an outer join yes or no ?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
Can the default values be assigned to actual parameters?
What exactly do quotation marks around the table name do?
Why cursor variables are easier to use than cursors?
Oracle General 
