Oracle 10g R2 -- ORA-00600: internal error code, arguments: [15598]

Problem

You execute an UPDATE statement and get an error similar to below:

ORA-00600: internal error code, arguments: [15598], [], [], [], [], [], [], []
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1204
ORA-06512: at "SYS.DBMS_SQL", line 323
.
.
.
ORA-06512: at line 3


The statement is a table update statement through a view. The explain plan table registered in the trace file indicates that hash joins are being used for the statement.


The database version is Oracle Database 10.2.0.5. Compatibility is set to 10.2.0.3.

Solution

You might hit a known Bug 6664976, for which the cause is hash joins used for the execution plan. You can try to temporary disable hash joins at a statement level or session level to check if this is the case. 

To disable hash joins at query level use the opt_param hint:

/*+ opt_param('hash_join_enabled','false') */

To disable hash joins at the session level use the underscored parameter:

alter session set "_hash_join_enabled"=FALSE;

References:

• Oracle Database 10g R2 -- Disable Hash Joins Usage for Queries
• ORA-600:[15598] : While Running A Statement Involving Hash Join (Doc ID 557293.1)
• Bug 6664976 : ORA-600 [15598] WHEN RUNNING PROCEDURE TO UPDATE TABLE