ORA-600[13001] On DELETE With GV$ In A SUBQUERY (Doc ID 357434.1)

Last updated on MARCH 29, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.4 to 11.1.0.6 [Release 8.1.7 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 29-May-2013***


Symptoms

Oracle 10.1.0.4.0 running on a Windows 2000 server.
Three node RAC database.
Also using MTS

Frequently getting ORA-600 errors.
ORA-00600: internal error code, arguments: [13001], [], [], [], [], [], [], []

Failing statement is :

DELETE FROM TR_FXS_LOCK T
WHERE T.SESSION_ID NOT IN
( SELECT TO_NUMBER(NVL(SUBSTR(V.CLIENT_INFO,
INSTR(V.CLIENT_INFO,'(',1)+1,INSTR(V.CLIENT_INFO,')',1)-(INSTR(V.CLIENT_INFO,'(',1)+1)),'-1'))
FROM GV$SESSION V
WHERE V.CLIENT_INFO LIKE 'FXSCon (%' )


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms