|
Index >
ORACLE Server Parameters >
hash_area_size
hash_area_size
Oracle 10.0.1:
| Paramter Name: | hash_area_size
| | Description: | size of in-memory hash work area
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | FALSE
|
Oracle 9.2.0:
| Paramter Name: | hash_area_size
| | Description: | size of in-memory hash work area
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | FALSE
|
Oracle 8.1.7:
| Paramter Name: | hash_area_size
| | Description: | size of in-memory hash work area
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | FALSE
|
Oracle 8.0.6:
| Paramter Name: | hash_area_size
| | Description: | size of in-memory hash work area
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | FALSE
|
Oracle 7.3.4:
| Paramter Name: | hash_area_size
| | Description: | size of in-memory hash work area
| | Type: | NUMBER
| Obsoleted: | FALSE
| | Can ALTER SESSION: | TRUE
| Can ALTER SYSTEM: | FALSE
|
Related Error Messages:
ORA-06580: Hash Join ran out of memory while keeping large rows in memoryCause: Hash Join reserves 3 slots (each slot size = DB_BLOCK_SIZE *
HASH_JOIN_MULTIBLOCK_IO_COUNT) for a row. If a row is larger than
that, this error will be raised.
Action: Increase HASH_JOIN_MULTIBLOCK_IO_COUNT so that each joined row
fits in a slot. HASH_AREA_SIZE may also need to be increaed.
This parameter is documented in the
Oracle Server Reference Guide.
Search for more info about
[ hash_area_size ]
on the Oracle FAQ.
| 
