ORA-06580: Hash Join ran out of memory while keeping large
rows in memory
- 1 Answers
- 3923 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-27007: failed to open file
NID-00425: Database name restored to string.
ORA-19675: file string was modified during proxy copy
IMG-00579: extra quantize argument
LFI-00149: Error on destroying hash table in function string
ORA-23424: materialized view "string"."string" at string not registered
ORA-15192: invalid ASM disk header [string] [string] [string] [string] [string]
ORA-29304: tablespace 'string' does not exist
ORA-30756: cannot create column or table of type that contains a supertype attribute
ORA-24330: internal OCI error
ORA-26712: remote object is "string"."string"\@"string"
TNS-04013: CMCTL timed out waiting for Oracle Connection Manager to start
Oracle Errors 
