OB_CLIENT_ID_TRACE_ENABLE

2026-02-11 07:43:39  Updated

The OB_CLIENT_ID_TRACE_ENABLE procedure enables end-to-end diagnostics at the client identifier level.

Applicability

This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.

Syntax

DBMS_MONITOR.OB_CLIENT_ID_TRACE_ENABLE(
 client_id    IN  VARCHAR2,
  level        IN  INT,
  sample_pct   IN  NUMBER,
  record_policy IN VARCHAR2);

Parameters

Parameter Description
client_id The ID of the client for which the end-to-end diagnostics feature is to be enabled.
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:
  • ALL: specifies to print traces for all sampled queries.
  • ONLY_SLOW_QUERY: specifies to print traces only for slow queries.
  • - SAMPLE_AND_SLOW_QUERY: specifies to print traces for slow queries, and to print traces for other queries based on the probability specified by _print_sample_percentage.

Contact Us