Which of the following will reduce the number of disk sorts?
A. Increasing SORT_AREA_SIZE.
B . Increasing the SORT_MEMORY_ALLOCATED parameter.
C . Decreasing SORT_AREA_RETAINED_SIZE.
D . Altering SORT_AREA_SIZE dynamically, based on available memory within SGA_MAX_SIZE.
Explanation:
Answer A: The value of SORT_AREA_SIZE determines the amount of memory that can be used for sorting operations; a lower value increases the likelihood that sorting will overflow the area and require disk extents. Increasing the size of the sort area will reduce free memory available to the remaining processes on the database server, but will also reduce the likelihood that sort operations will require disk space allocated from the temporary tablespace. SORT_AREA_SIZE, if too large, can contribute to paging and swapping.
No comments:
Post a Comment