Multiple choice

An application that uses a database keeps cursors open. What should be confirmed before changing the CURSOR_SPACE_FOR_TIME parameter in the database initialization file to TRUE?

  1. The TIMED_STATISTICS parameter is set to TRUE.

  2. The hit percentage in the buffer cache is at least 95%.

  3. The OPEN_CURSOR parameter is set to at least twice the default value.
  4. The value in the RELOADS column of V$LIBRARYCACHE is consistently zero or close to zero.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

CURSOR_SPACE_FOR_TIME=TRUE keeps cursors in memory to reduce reparsing. Before setting it, confirm V$LIBRARYCACHE shows RELOADS at or near zero, indicating cursors aren't being reloaded. This prevents wasting memory if the cache is already ineffective.

Keep practicing — related questions