questions - Question:Which of the following will reduce the number of disk sorts?

a.        Increasing SORT_AREA_SIZE
b.        Decreasing SORT_AREA_RETAINED_SIZE
c.        Increasing the SORT_MEMORY_ALLOCATED parameter
d.        Altering SORT_AREA_SIZE dynamically based on available memory within SGA_MAX_SIZE

asked Sep 13, 2013 in MYSQL by anonymous
edited Sep 12, 2013
0 votes

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.