Overview
Displays the configuration information related to write requests.
Columns
Column |
Type |
Is NULL |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | Tenant ID.
|
| SNAP_INTERVAL | varchar(64) | NO | The interval between each snapshot, in the format of DD HH:mm:SS Easy to read |
| RETENTION | varchar(64) | NO | The retention period between snapshots, in the format of DD HH:mm:SS Easy to read |
| TOPNSQL | bigint(20) | NO | SQL for Storing the Top N |
Sample query
View the configuration information related to write requests.
obclient [oceanbase]> SELECT * FROM oceanbase.DBA_WR_CONTROL LIMIT 1\G
The query result is as follows:
*************************** 1. row ***************************
TENANT_ID: 1
SNAP_INTERVAL: +0 01:00:00
RETENTION: +7 00:00:00
TOPNSQL: 30
1 row in set (0.008 sec)