ORA-600 [kxfpqsod_qc_sod] During Parallel Queries With Nested-loop and Filter Plans
(Doc ID 1954837.1)
Last updated on FEBRUARY 21, 2024
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 |