OB_SESSION_TRACE_ENABLE is used to enable session-level end-to-end diagnosis.
Applicability
This content 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 session_id for enabling end-to-end diagnosis. If empty, it represents the session_id of the current session. |
| level | The trace collection level for end-to-end diagnosis, which is an integer. |
| sample_pct | The sampling percentage, with a range of [0,1]. |
| record_policy | The printing policy, including the following options:
|