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
- 4324 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-27121: unable to determine size of shared memory segment
ORA-16184: DB_UNIQUE_NAME string hashes to the same value as DB_UNIQUE_NAME string
NNL-00298: No cache dump currently scheduled
ORA-13456: GeoRaster cell data error
DRG-11723: phrase cannot be NULL
RMAN-06589: cannot specify DB_FILE_NAME_CONVERT option without AS COPY
ORA-15063: diskgroup "string" lacks quorum of string PST disks; string found
ORA-02836: Unable to create temporary key file
PLS-00540: object not supported in this context.
ORA-32579: password for SYSTEM already specified
ORA-29950: warning in the execution of ODCIINDEXMERGEPARTITION routine
ORA-01555: snapshot too old: rollback segment number string with name "string" too small
Oracle Errors 
