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 should be set to TRUE only when V$LIBRARYCACHE RELOADS is consistently zero or close to zero. This parameter prevents cursor aging out of the shared pool, but if reloads are occurring, it will worsen performance by keeping more cursors in memory while still requiring reloads. Options A, B, and C are incorrect because TIMED_STATISTICS, buffer cache hit ratio, and OPEN_CURSOR settings are unrelated to the CURSOR_SPACE_FOR_TIME decision.

Keep practicing — related questions