Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Packages

PACKAGE DBMS_MONITOR

The DBMS_MONITOR package is installed by default in Oracle 10.1 and above.

Subroutines include:

Session Level Subroutines
PROCEDURE SESSION_TRACE_ENABLE
PROCEDURE SESSION_TRACE_DISABLE
Database Level Subroutines
PROCEDURE DATABASE_TRACE_ENABLE
PROCEDURE DATABASE_TRACE_DISABLE
Client ID Subroutines
PROCEDURE CLIENT_ID_TRACE_ENABLE
PROCEDURE CLIENT_ID_TRACE_DISABLE
PROCEDURE CLIENT_ID_STAT_ENABLE
PROCEDURE CLIENT_ID_STAT_DISABLE
Service / Module / Action subroutines
PROCEDURE SERV_MOD_ACT_TRACE_ENABLE
PROCEDURE SERV_MOD_ACT_TRACE_DISABLE
PROCEDURE SERV_MOD_ACT_STAT_ENABLE
PROCEDURE SERV_MOD_ACT_STAT_DISABLE

The DATABASE_TRACE_ENABLE and DATABASE_TRACE_DISABLE procedures were introduced in Oracle 10.2.