Multiple choice

What must be confirmed before changing the CURSOR_SPACE_FOR_TIME parameter in the 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.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

CURSOR_SPACE_FOR_TIME parameter set to TRUE tells Oracle to keep cursors in memory even when not in use, trading memory for performance. Before enabling this, you must confirm that RELOADS in V$LIBRARYCACHE is consistently zero - meaning SQL statements aren't being reloaded, indicating sufficient shared pool memory.

Keep practicing — related questions