DBA_WR_CONTROL

2026-02-05 05:53:37  Updated

Note

This view is introduced since OceanBase Database V4.2.1.

Purpose

The DBA_WR_CONTROL view displays Workload Repository (WR) configurations.

Columns

Column Type Nullable? Description
TENANT_ID NUMBER(38) NO The ID of the tenant.
  • Other values: a user tenant or meta tenant.
  • SNAP_INTERVAL VARCHAR2(64) NO The time interval between snapshots, in the DD HH:mm:SS format.
    RETENTION VARCHAR2(64) NO The retention period of snapshots, in the DD HH:mm:SS format.
    TOPNSQL NUMBER(38) NO The top N SQL statements stored.

    Contact Us