What are the factors causing the reparsing of SQL statements
in SGA?
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 |
Describe an oracle table?
Can we commit inside a function in oracle?
What happens if you set the sga too low in oracle?
What is meant by joins? List out the types of joins.
How to start a specific oracle instance?
How do I know if oracle is installed on windows?
how to join query for one source type is oracle another source type is sql server ?
What is oracle rowcount?
What is an oracle database?
what is the difference between joins and set operators.i am always confusing with two,can u pls kindly help me .
How many different types of indexes we have in oracle?
24 Answers IBM, TCS,
which sql command we can use to get a print out from oracle?