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 will be available on generic Linux platforms in January and soon on AIX and Windows

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