What Are The Factors Causing The Re Parsing Of Sql Statements In Sga?

1.	What Are The Factors Causing The Re Parsing Of Sql Statements In Sga?
Answer» 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.

Answer»

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.

Discussion