ORA-00700: Soft Internal Error, Arguments: [dbghmo_read_msgobj_mt_bygrpid]
(Doc ID 2269649.1)
Last updated on FEBRUARY 23, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.2 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
ORA-00700: soft internal error, arguments: [dbghmo_read_msgobj_mt_bygrpid], [3], [], [], [], [], [], [], [], [], [], [] generated out of dbms_stats/ SYS.DBMS_SQLTUNE_INTERNAL
Current SQL Statement for this session (sql_id=9rbm4jmvz13vh) -----
/* SQL Analyze(0) */ select /*+ full(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring xmlindex_sel_idx_tbl no_substrb_pad */to_char(count("ADDR")),substrb(dump(min("ADDR"),16,0,64),1,240),substrb(dump(max("ADDR"),16,0,64),1,240),to_char(count("INDX")),substrb(dump(min("INDX"),16,0,64),1,240),substrb(dump(max("INDX"),16,0,64),1,240),to_char(count("INST_ID")),substrb(dump(min("INST_ID"),16,0,64),1,240),substrb(dump(max("INST_ID"),16,0,64),1,240),to_char(count("CON_ID")),substrb(dump(min("CON_ID"),16,0,64),1,240),substrb(dump(max("CON_ID"),16,0,64),1,240),to_char(count("ID")),substrb(dump(min("ID"),16,0,64),1,240),substrb(dump(max("ID"),16,0,64),1,240),to_char(count("RUN_ID")),substrb(dump(min("RUN_ID"),16,0,64),1,240),substrb(dump(max("RUN_ID"),16,0,64),1,240),to_char(count("PID")),substrb(dump(min("PID"),16,0,64),1,240),substrb(dump(max("PID"),16,0,64),1,240),to_char(count("NAME")),substrb(dump(min("NAME"),16,0,64),1,240),substrb(dump(max("NAME"),16,0,64),1,240),to_char(count("NAMEID")),substrb(dump(min("NAMEID"),16,0,64),1,240),substrb(dump(max("NAMEID"),16,0,64),1,240),to_char(count("CLSNAME")),substrb(dump(min("CLSNAME"),16,0,64),1,240),substrb(dump(max("CLSNAME"),16,0,64),1,240),to_char(count("CLSNAMEID")),substrb(dump(min("CLSNAMEID"),16,0,64),1,240),substrb(dump(max("CLSNAMEID"),16,0,64),1,240),to_char(count("CTIME")),substrb(dump(min("CTIME"),16,0,64),1,240),substrb(dump(max("CTIME"),16,0,64),1,240),to_char(count("MTIME")),substrb(dump(min("MTIME"),16,0,64),1,240),substrb(dump(max("MTIME"),16,0,64),1,240),to_char(count("TYPE")),substrb(dump(min("TYPE"),16,0,64),1,240),substrb(dump(max("TYPE"),16,0,64),1,240),to_char(count("STATUS")),substrb(dump(min("STATUS"),16,0,64),1,240),substrb(dump(max("STATUS"),16,0,64),1,240),to_char(count("PRIORITY")),substrb(dump(min("PRIORITY"),16,0,64),1,240),substrb(dump(max("PRIORITY"),16,0,64),1,240),to_char(count("FLAGS")),substrb(dump(min("FLAGS"),16,0,64),1,240),substrb(dump(max("FLAGS"),16,0,64),1,240),to_char(count("VERSION")),substrb(dump(min("VERSION"),16,0,64),1,240),substrb(dump(max("VERSION"),16,0,64),1,240),to_char(count("CID_COUNT")),substrb(dump(min("CID_COUNT"),16,0,64),1,240),substrb(dump(max("CID_COUNT"),16,0,64),1,240),to_char(count("MSG_GRPID")),substrb(dump(min("MSG_GRPID"),16,0,64),1,240),substrb(dump(max("MSG_GRPID"),16,0,64),1,240),to_char(count("NUM_MSG")),substrb(dump(min("NUM_MSG"),16,0,64),1,240),substrb(dump(max("NUM_MSG"),16,0,64),1,240),to_char(count("DAMAGE_MSGGRP_ID")),substrb(dump(min("DAMAGE_MSGGRP_ID"),16,0,64),1,240),substrb(dump(max("DAMAGE_MSGGRP_ID"),16,0,64),1,240),to_char(count("NUM_DAMAGE_MSG")),substrb(dump(min("NUM_DAMAGE_MSG"),16,0,64),1,240),substrb(dump(max("NUM_DAMAGE_MSG"),16,0,64),1,240),to_char(count("HASH_CODE")),substrb(dump(min("HASH_CODE"),16,0,64),1,240),substrb(dump(max("HASH_CODE"),16,0,64),1,240),to_char(count("FDG_MSG")),substrb(dump(min("FDG_MSG"),16,0,64),1,240),substrb(dump(max("FDG_MSG"),16,0,64),1,240),to_char(count("DAMAGE_MSG")),substrb(dump(min("DAMAGE_MSG"),16,0,64),1,240),substrb(dump(max("DAMAGE_MSG"),16,0,64),1,240),to_char(count("CLOSE_REASON")),substrb(dump(min("CLOSE_REASON"),16,0,64),1,240),substrb(dump(max("CLOSE_REASON"),16,0,64),1,240),to_char(count("RDBMS_INSTANCE")),substrb(dump(min("RDBMS_INSTANCE"),16,0,64),1,240),substrb(dump(max("RDBMS_INSTANCE"),16,0,64),1,240),to_char(count("SPARE")),substrb(dump(min("SPARE"),16,0,64),1,240),substrb(dump(max("SPARE"),16,0,64),1,240) from "SYS"."X$DBKFDG" t /* NDV,NIL,NIL,ACL,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL*/
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x543842f00 145 package body SYS.DBMS_SQLTUNE_INTERNAL
0x543842f00 13094 package body SYS.DBMS_SQLTUNE_INTERNAL
0x543842f00 13730 package body SYS.DBMS_SQLTUNE_INTERNAL
0x543842f00 18936 package body SYS.DBMS_SQLTUNE_INTERNAL
0x542ea1c30 9340 package body SYS.DBMS_STATS_INTERNAL
0x53241ba98 30293 package body SYS.DBMS_STATS
0x53241ba98 31451 package body SYS.DBMS_STATS
0x53241ba98 33137 package body SYS.DBMS_STATS
0x53241ba98 34029 package body SYS.DBMS_STATS
0x53241ba98 34972 package body SYS.DBMS_STATS
0x53241ba98 35663 package body SYS.DBMS_STATS
0x53241ba98 36842 package body SYS.DBMS_STATS
0x53241ba98 36881 package body SYS.DBMS_STATS
0x5026688a0 1 anonymous block
/* SQL Analyze(0) */ select /*+ full(t) no_parallel(t) no_parallel_index(t) dbms_stats cursor_sharing_exact use_weak_name_resl dynamic_sampling(0) no_monitoring xmlindex_sel_idx_tbl no_substrb_pad */to_char(count("ADDR")),substrb(dump(min("ADDR"),16,0,64),1,240),substrb(dump(max("ADDR"),16,0,64),1,240),to_char(count("INDX")),substrb(dump(min("INDX"),16,0,64),1,240),substrb(dump(max("INDX"),16,0,64),1,240),to_char(count("INST_ID")),substrb(dump(min("INST_ID"),16,0,64),1,240),substrb(dump(max("INST_ID"),16,0,64),1,240),to_char(count("CON_ID")),substrb(dump(min("CON_ID"),16,0,64),1,240),substrb(dump(max("CON_ID"),16,0,64),1,240),to_char(count("ID")),substrb(dump(min("ID"),16,0,64),1,240),substrb(dump(max("ID"),16,0,64),1,240),to_char(count("RUN_ID")),substrb(dump(min("RUN_ID"),16,0,64),1,240),substrb(dump(max("RUN_ID"),16,0,64),1,240),to_char(count("PID")),substrb(dump(min("PID"),16,0,64),1,240),substrb(dump(max("PID"),16,0,64),1,240),to_char(count("NAME")),substrb(dump(min("NAME"),16,0,64),1,240),substrb(dump(max("NAME"),16,0,64),1,240),to_char(count("NAMEID")),substrb(dump(min("NAMEID"),16,0,64),1,240),substrb(dump(max("NAMEID"),16,0,64),1,240),to_char(count("CLSNAME")),substrb(dump(min("CLSNAME"),16,0,64),1,240),substrb(dump(max("CLSNAME"),16,0,64),1,240),to_char(count("CLSNAMEID")),substrb(dump(min("CLSNAMEID"),16,0,64),1,240),substrb(dump(max("CLSNAMEID"),16,0,64),1,240),to_char(count("CTIME")),substrb(dump(min("CTIME"),16,0,64),1,240),substrb(dump(max("CTIME"),16,0,64),1,240),to_char(count("MTIME")),substrb(dump(min("MTIME"),16,0,64),1,240),substrb(dump(max("MTIME"),16,0,64),1,240),to_char(count("TYPE")),substrb(dump(min("TYPE"),16,0,64),1,240),substrb(dump(max("TYPE"),16,0,64),1,240),to_char(count("STATUS")),substrb(dump(min("STATUS"),16,0,64),1,240),substrb(dump(max("STATUS"),16,0,64),1,240),to_char(count("PRIORITY")),substrb(dump(min("PRIORITY"),16,0,64),1,240),substrb(dump(max("PRIORITY"),16,0,64),1,240),to_char(count("FLAGS")),substrb(dump(min("FLAGS"),16,0,64),1,240),substrb(dump(max("FLAGS"),16,0,64),1,240),to_char(count("VERSION")),substrb(dump(min("VERSION"),16,0,64),1,240),substrb(dump(max("VERSION"),16,0,64),1,240),to_char(count("CID_COUNT")),substrb(dump(min("CID_COUNT"),16,0,64),1,240),substrb(dump(max("CID_COUNT"),16,0,64),1,240),to_char(count("MSG_GRPID")),substrb(dump(min("MSG_GRPID"),16,0,64),1,240),substrb(dump(max("MSG_GRPID"),16,0,64),1,240),to_char(count("NUM_MSG")),substrb(dump(min("NUM_MSG"),16,0,64),1,240),substrb(dump(max("NUM_MSG"),16,0,64),1,240),to_char(count("DAMAGE_MSGGRP_ID")),substrb(dump(min("DAMAGE_MSGGRP_ID"),16,0,64),1,240),substrb(dump(max("DAMAGE_MSGGRP_ID"),16,0,64),1,240),to_char(count("NUM_DAMAGE_MSG")),substrb(dump(min("NUM_DAMAGE_MSG"),16,0,64),1,240),substrb(dump(max("NUM_DAMAGE_MSG"),16,0,64),1,240),to_char(count("HASH_CODE")),substrb(dump(min("HASH_CODE"),16,0,64),1,240),substrb(dump(max("HASH_CODE"),16,0,64),1,240),to_char(count("FDG_MSG")),substrb(dump(min("FDG_MSG"),16,0,64),1,240),substrb(dump(max("FDG_MSG"),16,0,64),1,240),to_char(count("DAMAGE_MSG")),substrb(dump(min("DAMAGE_MSG"),16,0,64),1,240),substrb(dump(max("DAMAGE_MSG"),16,0,64),1,240),to_char(count("CLOSE_REASON")),substrb(dump(min("CLOSE_REASON"),16,0,64),1,240),substrb(dump(max("CLOSE_REASON"),16,0,64),1,240),to_char(count("RDBMS_INSTANCE")),substrb(dump(min("RDBMS_INSTANCE"),16,0,64),1,240),substrb(dump(max("RDBMS_INSTANCE"),16,0,64),1,240),to_char(count("SPARE")),substrb(dump(min("SPARE"),16,0,64),1,240),substrb(dump(max("SPARE"),16,0,64),1,240) from "SYS"."X$DBKFDG" t /* NDV,NIL,NIL,ACL,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL,NDV,NIL,NIL*/
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x543842f00 145 package body SYS.DBMS_SQLTUNE_INTERNAL
0x543842f00 13094 package body SYS.DBMS_SQLTUNE_INTERNAL
0x543842f00 13730 package body SYS.DBMS_SQLTUNE_INTERNAL
0x543842f00 18936 package body SYS.DBMS_SQLTUNE_INTERNAL
0x542ea1c30 9340 package body SYS.DBMS_STATS_INTERNAL
0x53241ba98 30293 package body SYS.DBMS_STATS
0x53241ba98 31451 package body SYS.DBMS_STATS
0x53241ba98 33137 package body SYS.DBMS_STATS
0x53241ba98 34029 package body SYS.DBMS_STATS
0x53241ba98 34972 package body SYS.DBMS_STATS
0x53241ba98 35663 package body SYS.DBMS_STATS
0x53241ba98 36842 package body SYS.DBMS_STATS
0x53241ba98 36881 package body SYS.DBMS_STATS
0x5026688a0 1 anonymous block
Stack Trace:
<- dbghmo_read_msgobj_ <- mt_bygrpid <- dbkhx_prepare_msg <- dbkfdgcb <- qerfxFetch <- qerandvFetch
<- qergsFetch <- opifch2 <- kpoal8 <- opiodr <- kpoodrc <- rpiswu2 <- kpoodr <- upirtrc <- kpurcsc <- kpufch0
<- kpufch <- OCIStmtFetch2 <- qksanExecSql <- qksanAnalyzeSqlConC <- qksanAnalyzeSql
<- qksanAnalyzeSegSql <- kestsGatherSqlStati <- stics <- kestsProcessSql <- kestsProcessSqlCall
<- out <- spefcmpa <- out <- 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
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 |