HASH_AREA_SIZE - Tuning

Does anyone know where hash joins are done if the init.ora parameter HASH_AREA_SIZE is left at its default of 0?

In what situations would the HASH_AREA_SIZE need to be larger than 0?

I can't find this information in any of my tuning references.

--
Cherie Machler
Consultant, Data By Design, Inc.
cmachler_at_winternet.com Received on Wed Apr 15 1998 - 06:40:42 CDT