Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-06580: Hash Join ran out of memory while keeping large
rows in memory
- 1 Answers
- 4353 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-01251: Unknown File Header Version read for file number string
ORA-06923: CMX: illegal break condition
ORA-30019: Illegal rollback Segment operation in Automatic Undo mode
ORA-30077: illegal casting between specified datetime types
TNS-12609: TNS: Receive timeout occurred
ORA-09836: addCallback: could not add a port to the callback set.
NZE-28754: object storage failure
ORA-32147: Environment not specified
RMAN-06531: CHANGE ... KEEP not supported for incremental BACKUPSET
ORA-09786: sllfop: open error, unable to open file.
RMAN-05009: Block Media Recovery requires Enterprise Edition
ORA-31433: subscriber view does not exist
Oracle Errors 
