Oracle Memory Management Question:
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.
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.
| Previous Question | Next Question |
| What is a data segment? | What is Database Buffers? |