Integer 

Dynamic. Scope= ALTER SESSION. 

Derived: 2 * value of SORT_AREA_SIZE parameter 

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.