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
- 4260 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-22613: buflen does not match the size of the scalar
ORA-27141: invalid process ID
RMAN-06595: platform name 'string' does not match database platform name 'string'
ORA-12065: unknown refresh group identifier string
QSM-01121: materialized view, string, is TRUSTED in ENFORCED integrity mode
TNS-00113: Failed to open error log file
ORA-00256: cannot translate archive destination string string
NNL-00007: server responded with an error
ORA-31662: metadata transform name can not be defaulted
ORA-01266: Unable to create unique file name
TNS-12661: Protocol authentication to be used
TNS-00209: Tracing : string
Oracle Errors 
