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
- 4436 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-19909: datafile string belongs to an orphan incarnation
DRG-13102: index partition name must be specified
ORA-06530: Reference to uninitialized composite
ORA-13914: Threshold notification failed.
TNS-00140: Interchange specified was not found in network tables
ORA-27467: invalid datatype for string value
TNS-01007: quit | exit : exit LSNRCTL
DRG-11104: Oracle Text error:
LSX-00104: duplicate type "~S"
ORA-12608: TNS: Send timeout occurred
NNL-00570: save_config [<server_list>] : saves server configuration to parameter file
O2F-00310: Illegal or missing identifier name
Oracle Errors 
