ORA-600 [kghstack_free1] [papWorkSpace: qerpxMObjVecInit] Raised by Select Query on Partitioned Table
Last updated on OCTOBER 25, 2015
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.2 [Release 12.1]Information in this document applies to any platform.
Symptoms
Running a query with interbal partitioned table fails with following error:
ORA-600 [kghstack_free1] [papWorkSpace: qerpxMObjVecInit]
The call stack from the trace file shows functions like:
...
kghstack_free [KGH]
kkpapiItOpen [PART]
kkpapItOpen [PART]
qerpxMObjVecInit [Parallel_Execution]
qerpx_rowsrc_start [Parallel_Execution]
qerpxStart [Parallel_Execution]
qerleStart [SQL_Execution]
selexe0 []
...
kghstack_free [KGH]
kkpapiItOpen [PART]
kkpapItOpen [PART]
qerpxMObjVecInit [Parallel_Execution]
qerpx_rowsrc_start [Parallel_Execution]
qerpxStart [Parallel_Execution]
qerleStart [SQL_Execution]
selexe0 []
...
The issue happens when the query is run in parallel but does not reproduce when the query executes in serial.
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