What Are The Factors Causing The Reparsing Of Sql Statements In Sga?

1.	What Are The Factors Causing The Reparsing Of Sql Statements In Sga?
Answer» Due to insufficient shared 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. Database Logical &AMP; PHYSICAL Architecture

Answer»

Due to insufficient shared 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.
Database Logical &AMP; PHYSICAL Architecture

Discussion