ORA-06580: Hash Join ran out of memory while keeping large
rows in memory
- 1 Answers
- 3582 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: 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.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-14453: attempt to use a LOB of a temporary table, whose data has alreadybeen purged
ORA-38772: cannot add datafile 'string' - file could not be created
ORA-32833: failure string trying to release administration lock
ORA-01263: Name given for file destination directory is invalid
LSX-00253: branch is empty
ORA-12700: invalid NLS parameter value (string)
ORA-24391: invalid fetch operation
ORA-28046: Password change for SYS disallowed
ORA-01953: command no longer valid, see ALTER USER
ORA-38951: Target platform string not cross platform compliant
DRG-11107: invalid path specification: string
ORA-31122: The string operator has incorrect RHS value
Oracle Errors 
