Oracle: init parameter HASH_AREA_SIZE

The value of hash_area_size specifies the maximum amount of memory that can be used for a hash join.

If a query performs multiple hash joins, the value limits the memory for one operation, not the total for the query.

Oracle recommends to set pga_aggregate_target instead of setting hash_area_size.