DEVFYI - Developer Resource - FYI

What are the factors causing the reparsing of SQL statements in SGA?

ORACLE Interview Questions and Answers (Part 2)


(Continued from previous question...)

328. What are the factors causing the reparsing of SQL statements in SGA?

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. LOGICAL & PHYSICAL ARCHITECTURE OF DATABASE.

(Continued on next question...)

Other Interview Questions