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
- 4345 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-31644: unable to position to block number string in dump file "string"
ORA-15102: invalid POWER expression
ORA-07758: slemcw: invalid handle
ORA-22338: must specify CASCADE INCLUDING DATA when altering the final property
NCR-02003: NCRF: Invalid type passed to format interpreter.
ORA-25119: LOGGING/NOLOGGING option already specified
NCR-04004: NCRR: Invalid interface instance handle
TNS-01100: TNS returned error number when attempting to start the listener
ORA-00080: invalid global area specified by level string
ORA-32638: Non unique addressing in MODEL dimensions
ORA-27044: unable to write the header block of file
ORA-02849: Read failed because of an error
Oracle Errors 
