The DBMS_MONITOR system package allows users to control the behavior of end-to-end diagnosis using PL/SQL.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Privileges
To call the subprograms of the DBMS_MONITOR package, you must have the EXECUTE privilege. By default, the SYSDBA role has the EXECUTE privilege on this package.
Subprograms
The following table describes the DBMS_MONITOR subprograms supported by the current OceanBase Database version.
| subprogram | Description |
|---|---|
| OB_SESSION_TRACE_ENABLE | Enables session-level end-to-end diagnosis. |
| OB_SESSION_TRACE_DISABLE | Disables session-level end-to-end diagnosis. |
| OB_CLIENT_ID_TRACE_ENABLE | Enables client_identifier-level end-to-end diagnosis |
| OB_CLIENT_ID_TRACE_DISABLE | Disables client_identifier-level end-to-end diagnosis. |
| OB_MOD_ACT_TRACE_ENABLE | Enables module/action-level end-to-end diagnosis. |
| OB_MOD_ACT_TRACE_DISABLE | Disables module/action-level end-to-end diagnosis. |
| OB_TENANT_TRACE_ENABLE | Enables end-to-end diagnosis for the current tenant. |
| OB_TENANT_TRACE_DISABLE | Disables end-to-end diagnosis for the current tenant. |