1.138 HASH_AREA_SIZE
HASH_AREA_SIZE specifies the maximum amount of memory, in bytes, to be used for hash joins.
| Property | Description |
|---|---|
|
Parameter type |
Integer |
|
Default value |
Derived: 2 * |
|
Modifiable |
|
|
Modifiable in a PDB |
No |
|
Range of values |
0 to operating system-dependent |
|
Basic |
No |
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.
See Also:
-
Oracle Database Concepts for information on hash joins in general