The OB_SESSION_TRACE_ENABLE procedure enables end-to-end diagnostics at the session level.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Syntax
DBMS_MONITOR.OB_SESSION_TRACE_ENABLE(
session_id IN BINARY_INTEGER DEFAULT NULL,
level IN INT,
sample_pct IN NUMBER,
record_policy IN VARCHAR2);
Parameters
| Parameter | Description |
|---|---|
| session_id | The ID of the session for which the end-to-end diagnostics feature is to be enabled. If this parameter is not specified, the feature is enabled for the current session. |
| level | The trace collection level for the end-to-end diagnostics feature, which is an integer. |
| sample_pct | The sampling frequency. Value range: [0, 1]. |
| record_policy | The printing strategy. Valid values:
|