SPM Auto Purges with ORA-00600 [qsmoDeleteHeap2:9]
(Doc ID 2463428.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterInformation in this document applies to any platform.
Symptoms
- SPM auto purges with following errors:
ORA-00600: internal error code, arguments: [qsmoDeleteHeap2:9], [], [], [], [], [], [], [], [], [], [], []
[TOC00001-END]
[TOC00002]
========= Dump for incident 265679 (ORA 600 [qsmoDeleteHeap2:9]) ========
*** 2018-09-11 16:32:30.730
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
[TOC00003]
----- Current SQL Statement for this session (sql_id=cnq31548hb8un) -----
BEGIN :c := dbms_spm_internal.auto_purge_sql_plan_baseline; END;
[TOC00004]
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
00007FFC2B573D18 302 package body SYS.DBMS_SPM
00007FFC2B573D18 1642 package body SYS.DBMS_SPM
00007FFC1F95D668 1074 package body SYS.DBMS_SPM_INTERNAL
00007FFC1F9D16A8 1 anonymous block
[TOC00004-END]
[TOC00003-END]
[TOC00005]
----- Call Stack Trace -----
qsmoFindObjPlanById <- qsmoDeleteHeap2 <- 681 <- qsmoChangeHeap2 <- qsmoObjChange
<- kglFlushHeaps <- kglfls1 <- ktcCommitTxn_new <- 20468 <- ktcCommitTxn
<- qsmoDrop <- qsmoDropPlansExt <- 863 <- spefcmpa <- spefmccallstd
<- pextproc <- peftrusted <- psdexsp <- rpiswu2 <- kxe_push_env_intern
<- al_pp_ <- kkx_push_env_for_IC <- D_for_new_session <- psdextp <- D_for_new_session
<- pefccal <- pefcal <- pevm_FCAL <- pfrinstr_FCAL <- pfrrun_no_tool
<- pfrrun <- plsql_run <- peicnt <- kkxexe <- opiexe
<- kpoal8 <- opiodr <- kpoodrc <- rpiswu2 <- kpoodr
<- xupirtrc <- upirtrc <- kpurcsc <- kpuexec <- OCIStmtExecute
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 |