ORA-06580: Hash Join ran out of memory while keeping large
rows in memory
- 1 Answers
- 3941 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 |
DRG-11442: valid gist numParagraphs values are string
TNS-02524: Authentication: privilege check failed
ORA-13781: The tuning task does not exist.
ORA-26085: direct path operation must start its own transaction
ORA-02212: duplicate PCTFREE option specification
ORA-06142: NETTCP: error getting user information
ORA-32117: Source LOB is null
ORA-39132: object type "string"."string" already exists with different hashcode
ORA-07284: sksaprd: volume size specification not terminated properly.
LSX-00147: "~1S" cannot contain "~2S"
NNL-00518: Shows or sets the maximum number of times a server can reforward a request
ORA-16759: Resource guard unable to start logical apply engine with initial SCN
Oracle Errors 
