ORA-06580: Hash Join ran out of memory while keeping large
rows in memory
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-16581: Data Guard NetSlave failed to send message to DRCX
LSX-00231: invalid unsigned integer "~S"
ORA-02822: Invalid block offset
TNS-01164: No spawn alias sent to listener
NZE-29234: a key object was not extracted from encoding
DRG-13001: sub lexer and multi lexer must have the same owner
ORA-12709: error while loading create database character set
TNS-00315: Failed to allocate larger connect data area for getting pump data: number
ORA-07750: slemcr: fopen failure
ORA-19641: backup datafile checkpoint is SCN string time string
ORA-00477: SNP* process terminated with error
ORA-14626: values being added already exist in DEFAULT subpartition