Initialization Parameters, 72 of 222

HASH_AREA_SIZE

Parameter type	Integer
Default value	Derived: 2 * `SORT_AREA_SIZE`
Parameter class	Dynamic: `ALTER SESSION`
Range of values	0 to operating system-dependent

Note:

Oracle does not recommend using the HASH_AREA_SIZE parameter unless the instance is configured with the shared server option. Oracle recommends that you enable automatic sizing of SQL working areas by setting PGA_AGGREGATE_TARGET instead. HASH_AREA_SIZE is retained for backward compatibility.

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:

Oracle9i Database Concepts for information on hash joins in general
Oracle9i Database Performance Tuning Guide and Reference for information on calculating an appropriate value for this parameter