Note
This view was introduced in OceanBase Database V4.2.1.
Purpose
This view displays the names of system statistics for all tenants.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| CLUSTER_ID | bigint(20) | NO | Cluster ID |
| TENANT_ID | bigint(20) | NO | Tenant ID |
| STAT_ID | bigint(20) | NO | Statistics ID |
| STAT_NAME | varchar(64) | NO | Statistics name |
Sample query
The following example queries the names of system statistics for all tenants.
obclient [oceanbase]> SELECT * FROM oceanbase.CDB_WR_STATNAME limit 1;
The result is as follows:
+------------+-----------+---------+---------------+
| CLUSTER_ID | TENANT_ID | STAT_ID | STAT_NAME |
+------------+-----------+---------+---------------+
| 4000 | 1 | 10000 | rpc packet in |
+------------+-----------+---------+---------------+
1 row in set (0.001 sec)