Note
This view is available starting with V4.2.1.
Purpose
This view displays the names of system statistics for the current tenant.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| CLUSTER_ID | NUMBER(38) | NO | The cluster ID. |
| TENANT_ID | NUMBER(38) | NO | The tenant ID. |
| STAT_ID | NUMBER(38) | NO | The ID of the system statistic. |
| STAT_NAME | VARCHAR2(64) | NO | The name of the system statistic. |
Sample query
Query the names of system statistics for the current tenant and display the first record.
obclient [SYS]> SELECT * FROM SYS.DBA_WR_STATNAME WHERE ROWNUM <= 1\G
The query result is as follows:
*************************** 1. row ***************************
CLUSTER_ID: 10001
TENANT_ID: 1004
STAT_ID: 10000
STAT_NAME: rpc packet in
1 row in set (0.063 sec)