ORA-06580: Hash Join ran out of memory while keeping large
rows in memory
- 1 Answers
- 3887 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 |
UDE-00005: unexpected End-Of-File encountered while reading input
NZE-28866: Invalid peer certificate encoding
NNO-00061: loading data for domain "string"
RMAN-06070: DBWR could not identify datafile string
IMG-00832: fail queue is full
PCC-01017: The SQLCA and a SQLCODE variable cannot both be used
NID-00370: Change database ID of database string? (Y/[N]) =>
ORA-30736: objects in a table or view hierarchy have to be in the same schema
ORA-29388: plan/consumer_group string is part of more than one top-plan
ORA-31515: CDC change source string already exists
ORA-02338: missing or invalid column constraint specification
ORA-02304: invalid object identifier literal
Oracle Errors 
