ORA-06580: Hash Join ran out of memory while keeping large
rows in memory
- 1 Answers
- 3544 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-09370: Windows 3.1 Two-Task driver ORACLE task timed out
DRG-50918: mismatched close escape character
RMAN-06118: a backup controlfile older than SCN string must be used for this recovery
EXP-00050: Cannot perform Partition Export "string" on non-partitioned table "string"
ORA-24385: Application context size or index is not valid
ORA-13156: table to be registered string.string is not empty
ORA-30332: container table already in use by other summary
ORA-19550: cannot use backup/restore functions while using dispatcher
ORA-06802: TLI Driver: could not open the /etc/netware/yellowpages file
ORA-02041: client database did not begin a transaction
LPX-00013: wrong node type
LSX-00010: extra element(s) at end of "~S"
Oracle Errors 
