DBMS_SQL_MONITOR.REPORT_SQL_MONITOR fails with ORA-14552 on Active DataGuard Standby
This works on the primary database, but not the standby.
it used to work when standby was 11.2.0.4.
19c, version 19.8
running with an id that has dba role.
select DBMS_SQL_MONITOR.REPORT_SQL_MONITOR(sql_id => 'icdassa8fr9', sql_exec_id=> '34723549') from dual;
ERROR:
ORA-14552: cannot perform a DDL, commit or rollback inside a query or DML
ORA-06512: at "SYS.DBMS_SQLTUNE_UTIL1", line 1117
ORA-06512: at "SYS.DBMS_SQLTUNE", line 13800
ORA-06512: at "SYS.DBMS_SQLTUNE", line 19007
ORA-06512: at "SYS.DBMS_SQL_MONITOR", line 573
ORA-06512: at line 1