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 |
Why packages are used in oracle?
How to loop through a cursor variable?
IS it possible to built the oracle database without setting the kernal parameters?
Why cursor variables are easier to use than cursors?
 What are the oracle DML commands possible through an update strategy?
How to install oracle odbc drivers?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
Explain oracle instance.
How to synchronize 2 schema's objects?
Which is faster join or subquery in oracle?
How to connect to a remote server?
hai, I am searching job on Oracle10g and PL/sql,Unix... can any one send me resume format. an suggest me how to prepare.. ann books..