Re: HASH_AREA_SIZE - Tuning

Hi,
The default is 2 time the sort_area_size.

--
Regards LANGE Francois.
flange_at_pt.lu
29A Route du vin.
L5450 Stadtbredimus.
Grand Duchy Of Luxembourg.
TEL (int) 352 697412.(*)
CEL(int) 352 021193652(*)
Phone numbers are variable length in Luxembourg. Grand Duchy Of Luxembourg is a small country 80 miles on 60 miles between France,Germany and Belgium.

Cherie Machler <cmachler_at_winternet.com> wrote in article <01bd6863$ce9ba600$4243f6cc_at_pavilion>...
> 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 - 09:49:52 CDT