Tuning Sort and Hash Memory Areas by Jeff Maresh
If it ain't broke, don't fix it. That's often how sort and hash memory areas are treated. As long as users aren't complaining, neither of the two areas are tuned. If users start complaining about sort performance, one might increase sort_area_size by 50% and be done with it. But, how do you know that these two areas are properly tuned? If you've got a fixed amount of memory to dedicate per session to sorting and hash joins, how do you know that the memory is being divided properly between the two activities? Read on to find out an easy method for tuning these two dynamic memory areas.
When asked to "Select a payment method" for your free download, choose "Print and Call". Your download code will be e-mailed to you after we authorize it. International customers should enter TruTek's address as the shipping address and enter their real shipping address in the Special Instructions field on the payment screen.
- Author:: Jeff Maresh
- Item #: Paper0006
