OB_TENANT_TRACE_ENABLE

2024-06-28 05:30:31  Updated

OB_TENANT_TRACE_ENABLE is used to enable end-to-end diagnosis for the current tenant.

Applicability

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

Syntax

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

Parameters

Parameter Description
level: The trace collection level for end-to-end diagnosis functionality, which is an integer.
sample_pct: The sampling percentage, with a range of [0,1].
record_policy The printing policy, including the following options:
  • ALL: Print trace for all sampled queries.
  • ONLY_SLOW_QUERY: Print trace only for slow queries.
  • SAMPLE_AND_SLOW_QUERY: Print trace for slow queries, while other requests are printed based on the probability of _print_sample_percentage.

Contact Us