My Oracle Support Banner

ORA-600 [kxfpqsod_qc_sod] During Parallel Queries With Nested-loop and Filter Plans (Doc ID 1954837.1)

Last updated on MARCH 11, 2020

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.0. to 12.1.0.1 [Release 11.2 to 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

With Concurrent DDL and Parallel Workload(Queries+PMOP),Parallel queries with nested-loop and filter plans may fail with ORA-600 [kxfpqsod_qc_sod]

Trace file may contain the stack matching below:
 
STACK
------

 Error: ORA-600 [kxfpqsod_qc_sod] [] [] [] [] [] [] [] [] [] [] []
 [00]: dbgexProcessError [diag_dde]
 [01]: dbgeExecuteForError [diag_dde]
 [02]: dbgePostErrorKGE [diag_dde]
 [03]: dbkePostKGE_kgsf [rdbms_dde]
 [04]: kgeadse []
 [05]: kgerinv_internal []
 [06]: kgerinv []
 [07]: kgeasnmierr []
 [08]: kxfpqsod_qc_sod [Parallel_Execution]<-- Signaling
 [09]: kxfpqsod [Parallel_Execution]
 [10]: kxfrdel [Parallel_Execution]
 [11]: kxsffir [cursor]
 [12]: kxsFreeWorkArea [cursor]
 [13]: kxsFreeExecutionHeap [cursor]
[14]: kksumc [cursor]
[15]: kksCancelCursor [cursor]
 [16]: kksCloseCursor [cursor]
 [17]: opicca []
 [18]: kxsFastCloseCursor [cursor]
 [19]: kgscReleaseACursor []
 [20]: kgscReleaseCursorGroup []
 [21]: pfrust []
 [22]: pevm_RET []
 [23]: pfrinstr_RET []
 [24]: pfrrun_no_tool []
 [25]: pfrrun []
 [26]: plsql_run []
 [27]: peicnt []
 [28]: kkxexe []
 [29]: opiexe []
 [30]: kpoal8 []
 [31]: opiodr []
 [32]: ttcpip []
 [33]: opitsk []
 [34]: opiino []
 [35]: opiodr []
[36]: opidrv []
 [37]: sou2o []
 [38]: opimai_real []
 [39]: ssthrdmain []

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
Cause
Solution


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