OB_MOD_ACT_TRACE_ENABLE

2024-12-02 03:48:27  Updated

OB_MOD_ACT_TRACE_ENABLE is used to enable module/action-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_MOD_ACT_TRACE_ENABLE(
  module_name     IN VARCHAR2,
  action_name     IN VARCHAR2,
  level        IN  INT,
  sample_pct   IN  NUMBER,
  record_policy IN VARCHAR2);

Parameters

Parameter Description
module_name The module_name for enabling end-to-end diagnosis.
action_name The action_name for enabling end-to-end diagnosis.
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.
  • 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