The DBMS.MONITORT system package allows users to control end-to-end tracing behavior using PL/SQL.
Applicability
This content applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL-compatible mode.
DBMS_MONITOR Privileges
All subprograms of the DBMS_MONITOR system package require the user to have the EXECUTE privilege. By default, the SYSDBA role has the EXECUTE privilege on this system package.
Overview of DBMS_MONITOR Subprograms
The following table lists the DBMS_MONITOR subprograms supported by the current version of OceanBase Database and provides brief descriptions.
subprogram |
Description |
|---|---|
| OB_SESSION_TRACE_ENABLE | Enable end-to-end session-level tracing |
| OB_SESSION_TRACE_DISABLE | Disable end-to-end session-level tracing |
| OB_CLIENT_ID_TRACE_ENABLE | Enable end-to-end tracing at the client_identifier level |
| OB_CLIENT_ID_TRACE_DISABLE | Disable end-to-end tracing at the client_identifier level |
| OB_MOD_ACT_TRACE_ENABLE | Enable end-to-end tracing at the module/action level |
| OB_MOD_ACT_TRACE_DISABLE | Disable end-to-end tracing at the module/action level |
| OB_TENANT_TRACE_ENABLE | Enable End-to-End Tracing for the Current Tenant |
| OB_TENANT_TRACE_DISABLE | Disable end-to-end tracing for the current tenant |