The DBMS_MONITORT system package allows you to use PL/SQL to control additional tracing and statistics collection.
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 |
|---|---|
| CLIENT_ID_STAT_DISABLE | Disables statistics collection for a specific client identifier. |
| CLIENT_ID_STAT_ENABLE | Enables statistics collection for a specific client identifier. |
| CLIENT_ID_TRACE_DISABLE | Disables tracing for a specific client identifier within the whole database. |
| CLIENT_ID_TRACE_ENABLE | Enables tracing for a specific client identifier within the whole database. |
| DATABASE_TRACE_DISABLE | Disables SQL tracing for the whole database or a specific instance. |
| DATABASE_TRACE_ENABLE | Enables SQL tracing for the whole database or a specific instance. |
| SERV_MOD_ACT_STAT_DISABLE | Disables statistics collection for a combination of specific service names, modules, and actions. |
| SERV_MOD_ACT_STAT_ENABLE | Enables statistics collection for a combination of specific service names, modules, and actions. |
| SERV_MOD_ACT_TRACE_DISABLE | Disables tracing for a combination of specific service names, modules, and actions in all instances for which tracing is enabled. |
| SERV_MOD_ACT_TRACE_ENABLE | Enables SQL tracing for a combination of specific service names, modules, and actions in specified instances. |
| SESSION_TRACE_DISABLE | Disables tracing for a specific database session identifier in the local instance. |
| SESSION_TRACE_ENABLE | Enables tracing for a specific database session identifier in the local instance. |