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
- 4248 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-08003: sequence string.NEXTVAL exceeds internal limits
TNS-01099: %s * string * string * string * number
ORA-38446: Error with embedded ADT "string" in the attribute set.
ORA-02094: replication option not installed
TNS-00115: Could not allocate pump global buffers
ORA-04084: cannot change NEW values for this trigger type
ORA-23455: flavor string contains object "string"
TNS-01081: Started with pid=string
RMAN-06195: auxiliary database not started
ORA-02090: network error: attempted callback+passthru
SQL*Loader-00257: TERMINATED BY EOF option not valid with ENCLOSED BY option
ORA-01488: invalid nibble or byte in the input data
Oracle Errors 
