Multiple choice

Which of the following will reduce the number of disk sorts?

  1. Increasing SORT_AREA_SIZE

  2. Decreasing SORT_AREA_RETAINED_SIZE

  3. Increasing the SORT_MEMORY_ALLOCATED parameter

  4. Altering SORT_AREA_SIZE dynamically based on available memory within SGA_MAX_SIZE
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

SORT_AREA_SIZE determines how much memory is allocated for each sort operation. Increasing this parameter allows more sorts to complete entirely in memory, reducing the need to spill to disk (which is much slower). SORT_AREA_RETAINED_SIZE controls memory retained after sort completion and doesn't affect disk sort frequency.

Keep practicing — related questions