ORA-00600: [KXFXSSTATUS: NOJOIN BUT ALREADY SENT JOINOK] (Doc ID 1533077.1)

Last updated on MARCH 27, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 to 12.1.0.1 [Release 11.1 to 12.1]
Information in this document applies to any platform.

Symptoms

Select query can fail with the ORA-600 error message if parallel execution is being used.

As an example:

ORA-600: internal error code, arguments: [kxfxsStatus: nojoin but already sent joinOK]
----- Current SQL Statement for this session (sql_id=bp2sjs2dvkgdy) -----
select OBJOID, RETRYCNT, FLAGS, STATUS, ISLW, PARNT, JDESTID FROM ( select
a.obj# OBJOID, a.retry_count RETRYCNT, a.job_status STATUS, a.flags
FLAGS, a.running_instance RUNINST, 0 ISLW, 0 PARNT, a.job_dest_id JDESTID
from sys.scheduler$_job a union all select b.obj#, b.retry_count,
b.job_status, b.flags, b.running_instance, 1, decode(bitand(b.flags,
137438953472), 0, 0, b.program_oid), b.job_dest_id from
sys.scheduler$_lightweight_job b ) where bitand(STATUS, 2) = 2 and (
RUNINST = :1 or ( RUNINST is not null and RUNINST not in (select
inst_id from gv$instance)))

STACK:

kgeadse kgerinv_internal []
kgerinv []
kgeasnmierr []
kxfxsStatus [Parallel_Execution]<-- Signaling
qkaParallelizePost [SQL_Code_Generator]
qkadrv2Post [SQL_Code_Generator]
qkadrv2 [SQL_Code_Generator]
opitca []
kksFullTypeCheck [cursor]
rpiswu2 []
kksSetBindType [cursor]
kksfbc [cursor]
opiexe []
kpoal8 []



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