Oracle | DBMS_MANAGEMENT

Oracle DBMS_MANAGEMENT_DIAGNOSTICS Version 26ai

General Information

Library Note

Morgan's Library Page Header

The best Oracle News for FY2026

Oracle Database 26ai is now availble. If you haven't you downloaded already: Why?

Purpose Use this package to trace a specific client

AUTHID DEFINER

Dependencies

DBMS_UMF_LIB

Documented No

First Available 23ai

Pragmas PRAGMA SUPPLEMENTAL_LOG_DATA(default, UNSUPPORTED);

Security Model Owned by SYS with EXECUTE granted to the DBA role.

Source {ORACLE_HOME}/rdbms/admin/dbmsmd.sql
{ORACLE_HOME}/rdbms/admin/prvtmd.plb

Subprograms

Undocumented dbms_management_diagnostics.disable( client_name IN VARCHAR2, scope IN VARCHAR2 DEFAULT NULL, -- Database, Instance, Session destination IN VARCHAR2 DEFAULT NULL); -- Eventlog, Tracefile

exec dbms_management_diagnostics.enable('C##UWCLASS', 'Session', 'Tracefile');

           *

      ORA-15771 parameter [client name] is invalid: specified name does not exist

ENABLE (new 23ai)

Undocumented dbms_management_diagnostics.enable( client_name IN VARCHAR2, scope IN VARCHAR2 DEFAULT NULL, destination IN VARCHAR2 DEFAULT NULL);

exec dbms_management_diagnostics.enable('C##UWCLASS', 'Session', 'Tracefile');

           *

      ORA-15771 parameter [client name] is invalid: specified name does not exist

SET_GLOBAL_ATTRIBUTE (new 23ai)

Undocumented dbms_management_diagnostics.set_global_attribute( name IN VARCHAR2, value IN VARCHAR2);

TBD