ORA-06580: Hash Join ran out of memory while keeping large
rows in memory
- 1 Answers
- 3983 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-03207: subpartitioned type must be specified for composite object
LCD-00207: nested parentheses encountered [string]
ORA-16563: unable to add value, syntax error at "string"
KUP-04014: invalid SLF parameter
LPX-00411: unknown function name encountered
RMAN-06578: INCREMENTAL LEVEL > 0 must be specified with FOR RECOVER OF
ORA-26507: null master connection
ORA-01603: illegal grouping size in clause "string" of string
DRG-50853: fetch error
ORA-01953: command no longer valid, see ALTER USER
NID-00303: Datafile string - wrote new name
ORA-33452: (ESDREAD06) Discarding compiled code for workspace object because number is now dimensioned by workspace object. It was dimensioned by workspace object when the code was compiled.
Oracle Errors 
