ORA-06580: Hash Join ran out of memory while keeping large
rows in memory



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

Post New Answer

More Oracle Errors Interview Questions

ORA-23323: parameter length exceeds deferred RPC limits

1 Answers  


IMP-00054: must be connected 'AS SYSDBA' to do Point-in-time Recovery or Transportable Tablespace import

1 Answers  


ORA-16165: LGWR failed to hear from network server

1 Answers  


QSM-02033: no filter conditions are present in the WHERE clause

1 Answers  


DRG-12001: Please enter username:

1 Answers  






ORA-13029: Invalid SRID in the SDO_GEOMETRY object

1 Answers  


ORA-36668: (XSDPART06) string is not a legal RANGE partition.

1 Answers  


ORA-00091: LARGE_POOL_SIZE must be at least string

1 Answers  


QSM-01522: a more optimal equivlanece than string was used to rewrite

1 Answers  


ORA-00075: process "string" not found in this instance

1 Answers  


ORA-00272: error writing archive log string

1 Answers  


PLS-00326: IN clause must contain same number of expressions as subquery

1 Answers  


Categories