Database Utilities (MOSC)

MOSC Banner

DBMS_SQL_MONITOR.REPORT_SQL_MONITOR fails with ORA-14552 on Active DataGuard Standby

edited Mar 4, 2021 5:01PM in Database Utilities (MOSC) 7 comments

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center