Note
This view was introduced in OceanBase Database V4.2.1.
Purpose
This view displays the names of system statistics in the tenant.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| CLUSTER_ID | NUMBER(38) | NO | The ID of the cluster. |
| TENANT_ID | NUMBER(38) | NO | The ID of the tenant. |
| STAT_ID | NUMBER(38) | NO | The ID of the statistic. |
| STAT_NAME | VARCHAR2(64) | NO | The name of the statistic. |
Sample query
Query the names of system statistics in the tenant.
obclient [SYS]> SELECT * FROM SYS.DBA_WR_STATNAME limit 1;
The return result is as follows:
+------------+-----------+---------+---------------+
| CLUSTER_ID | TENANT_ID | STAT_ID | STAT_NAME |
+------------+-----------+---------+---------------+
| 4000 | 1 | 10000 | rpc packet in |
+------------+-----------+---------+---------------+
1 row in set (0.004 sec)