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.
The package is defined in $ORACLE_HOME/rdbms/admin/dbmsmntr.sql