Thursday, October 15, 2015

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


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 Compatibility is set to


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;


No comments: