My Oracle Support Banner

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

Last updated on MARCH 10, 2020

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=xxxxxxxxxxxxxx) -----
select COL1, COL2, COL3, COL4, COL5, COL6, COL7 FROM ( select
a.obj# COL1, a.COL8 COL2, a.job_status COL4, a.COL3
COL3, a.COL9 RUNINST, 0 COL5, 0 COL6, a.job_dest_id COL7
from sys.scheduler$_job a union all select b.obj#, b.COL8,
b.job_status, b.COL3, b.COL9, 1, decode(bitand(b.COL3,
137438953472), 0, 0, b.program_oid), b.job_dest_id from
sys.scheduler$_lightweight_job b ) where bitand(COL4, 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 []



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.