Oracle Memory Management Question:
Download Questions PDF

What are the factors causing the reparsing 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.

LOGICAL & PHYSICAL ARCHITECTURE OF DATABASE.

Download Memory Management Interview Questions And Answers PDF

Previous QuestionNext Question
What is a data segment?What is Database Buffers?