hash_area_size

We want to know the handling of the hash_area_size. We know that Oracle allocates hash_area_size on a per process basis and that the size is default 2 * sort_area_size. So will we have to reserve the memory for hash area for all processes in addition to sort area. Perhaps, Oracle will use sort area for hashing? Or is the memory for hash area is deallocate after hashing? And on MTS configuration the hash area is allocated in the shared pool? By the way, hash joins will speed up joins enormous.

Thanks you,

Andreas Prusch

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu May 28 1998 - 02:35:21 CDT