Analysis of ORA-00600: internal error code, arguments: [kxfxsStatus: nojoin but already sent joinOK]
Hi all, In the alert log we found the below ORA-600 internal error. Alert log Error is below: ORA-00600: internal error code, arguments: [kxfxsStatus: nojoin but already sent joinOK], [197888], [], [], [], [], [], [], [], [], [], [] We had to report this error with our analysis to our manager. We had searched the related document for this error in Oracle support website and found the following document. Bug 9785632 - Parallel query fails with OERI[kxfxsstatus: nojoin but already sent joinok] (Doc ID 9785632.8) As per above Doc ID 9785632.8, Affects:: Versions confirmed as being affected · 11.2.0.1 · 11.1.0.7 Fixed: This issue is fixed in · 12.1.0.1 (Base Release) · 11.2.0.2 (Server Patch Set) · 11.2.0.1 Bundle Patch 8 for Exadata Database Symptoms: · Internal Error May Occur (ORA-600) · ORA-600 [kxfxsStatus: nojoin but already sent joinOK] Description: ORA-600: