Generating SQL MONITOR Report throws ORA-13971 Error (Doc ID 2927234.1)

Last updated on APRIL 17, 2023

Applies to:

Symptoms

On : 19.12.1.0.0 version, RDBMS

Generating SQL MONITOR report throws ORA-13971 Error.

SQL> SELECT DBMS_SQLTUNE.report_sql_monitor(
2 sql_id => '******',
3 type => 'ACTIVE',
4 report_level => 'ALL') AS report
5 FROM dual;
ERROR:
ORA-13971: Unknown component
ORA-06512: at "SYS.DBMS_SQLTUNE", line 18940
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_REPORT", line 168
ORA-06512: at "SYS.DBMS_REPORT", line 711
ORA-06512: at "SYS.PRVT_REPORT_TAGS", line 25
ORA-06512: at "SYS.DBMS_SQLTUNE", line 18895
ORA-06512: at "SYS.DBMS_SQLTUNE", line 19036
ORA-06512: at "SYS.DBMS_SQLTUNE", line 19367
ORA-06512: at line 1

----- Error Stack Dump -----

<error barrier> at 0xffffffffffeeb40 placed dbkda.c@298
ORA-13971: Unknown component

----- Current SQL Statement for this session (sql_id=*****) -----
SELECT DBMS_SQLTUNE.report_sql_monitor(
sql_id => '*****',
type => 'ACTIVE',
report_level => 'ALL') AS report
FROM dual

----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
70001061fa30be0 86 package body SYS.DBMS_SYS_ERROR.RAISE_SYSTEM_ERROR
70001061eda22e0 168 package body SYS.DBMS_REPORT.LOOKUP_COMPONENT_ID
70001061eda22e0 711 package body SYS.DBMS_REPORT.PARSE_REPORT_REFERENCE
700010447e47cd8 25 package body SYS.PRVT_REPORT_TAGS.BUILD_REPORT_TAG
7000104b5f0be20 18895 package body SYS.DBMS_SQLTUNE.I_REPORT_SQL_MONITOR_XML
7000104b5f0be20 19036 package body SYS.DBMS_SQLTUNE.REPORT_SQL_MONITOR_XML
7000104b5f0be20 19367 package body SYS.DBMS_SQLTUNE.REPORT_SQL_MONITOR
700010092d78a08 1 anonymous block

----- Call Stack Trace -----
skdstdst <- ksedst1 <- ksedst <- dbkedDefDump <- ksedmp
<- dbkdaKsdActDriver <- dbgdaExecuteAction <- dbgdaRunAction <- IPRA <- IPRA
<- entActions <- dbgdChkEventKgErr <- dbkdChkEventRdbmsEr <- ksfpec <- dbgePostErrorKGE
<- 236 <- dbkePostKGE_kgsf <- IPRA <- kgerelv <- kserec1
<- kkxerse <- pevm_icd_call_commo <- pfrinstr_ICAL <- IPRA <- pfrrun
<- plsql_run <- peicnt <- kkxuexe <- kkxmpsexe <- IPRA
<- kgmexec <- evapls <- evaopn2 <- kpofcr <- qerfiFetch
<- opifch2 <- opifch <- opiodr <- ttcpip <- opitsk
<- opiino <- opiodr <- opidrv <- sou2o <- opimai_real
<- ssthrdmain <- main <- start

Cause

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