Note
This view is introduced since OceanBase Database V4.2.1.
Purpose
The oceanbase.CDB_WR_CONTROL view displays Workload Repository (WR) configurations.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO |
|
| SNAP_INTERVAL | varchar(64) | NO | The time interval between snapshots, in the DD HH:mm:SS format. |
| RETENTION | varchar(64) | NO | The retention period of snapshots, in the DD HH:mm:SS format. |
| TOPNSQL | bigint(20) | NO | The top N SQL statements stored. |