ora-06580 Hash Join out of memory

[tamilselvan]

There is NO harm in increasing both values.

I usually set hash_area_size to 64 MB and HASH_JOIN_MULTIBLOCK_IO_COUNT to 32.

Tamil