DBMS_SQL_MONITOR.REPORT_SQL_MONITOR Fails With ORA-32036
(Doc ID 1913431.1)
Last updated on AUGUST 04, 2018
Oracle Database - Enterprise Edition - Version 22.214.171.124 and later Information in this document applies to any platform.
The /*+ MONITOR */ hint has been included in a query in order to monitor its performance
select /*+ MONITOR */ count (*) from emp;
Monitoring the query using DBMS_SQL_MONITOR.REPORT_SQL_MONITOR fails with ORA-32036
SELECT DBMS_SQL_MONITOR.REPORT_SQL_MONITOR(session_id=>userenv('SID'), report_level=>'ALL') AS report FROM dual; ERROR: ORA-32036: unsupported case for inlining of query name in WITH clause ORA-06512: at "SYS.DBMS_SQLTUNE", line 16091 ORA-06512: at "SYS.DBMS_SQLTUNE", line 16187 ORA-06512: at "SYS.DBMS_SQL_MONITOR", line 509 ORA-06512: at line 1
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!