Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors causing the reparsing of SQL statements
in SGA?
- 2 Answers
- 5452 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 |
Give the sequence in which triggers fired during insert operations, when the following 3 triggers are defined at the same block level ?
Is a rollback possible to any savepoint?
What does COMMIT do ?
A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?
Explain the family trees and connection by clause
structural difference between bitmap and btree index ?
what is a cartition product?
What is oracle rowcount?
Does oracle charge for java?
List the types of joins used in writing subqueries?
What is the difference between Sleep and Wait? (Java)
What is clustered table in Oracle?
Oracle General 
