标题: ORA-06580: Hash Join ran out of memory while keeping large rows in memory [打印本页] 作者: admin 时间: 2016-7-27 15:39 标题: ORA-06580: Hash Join ran out of memory while keeping large rows in memory ORA-06580: Hash Joinran out of memory while keeping large rows in memory 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: IncreaseHASH_JOIN_MULTIBLOCK_IO_COUNT so that each joined
row fits in a slot. HASH_AREA_SIZE may also need to be increaed.