HASH_AREA_SIZE

Parameter type:	Integer
Parameter class:	Dynamic. Scope= ALTER SESSION.
Default value:	Derived: 2 * value of SORT_AREA_SIZE parameter
Range of values:	0 to operating system dependent value
HASH_AREA_SIZE is relevant to parallel execution operations and to the query portion of DML or DDL statements. It specifies the maximum amount of memory, in bytes, to be used for hash joins. See Also: Oracle8i Concepts for information on hash joins in general. Oracle8i Designing and Tuning for Performance for information on calculating an appropriate value for this parameter.