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
- 4350 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 |
PCC-00136: Invalid SQL_CURSOR declaration
NNL-01006: META VIOLATION responses received: number
NNO-00105: line string: invalid name "string", data ignored
ORA-27038: created file already exists
ORA-01186: file string failed verification tests
ORA-04080: trigger 'string' does not exist
LFI-00125: Random access only allowed on fixed length record files.
ORA-26083: unsupported direct path stream version string
ORA-01244: unnamed datafile(s) added to controlfile by media recovery
SQL*Loader-00478: unable to continue due to missing filename for LOBFILE or SDF
ORA-26685: cannot apply transactions from multiple sources
LPX-00316: invalid value ~S for ~S attribute ~S
Oracle Errors 
