Note
This view is available starting with V4.2.1.
Purpose
This view displays the details of system statistics for all tenants.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| CLUSTER_ID | NUMBER(38) | NO | The cluster ID. |
| TENANT_ID | NUMBER(38) | NO | The tenant ID. |
| SNAP_ID | NUMBER(38) | NO | The snapshot ID. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the node. |
| SVR_PORT | NUMBER(38) | NO | The port number of the node. |
| STAT_ID | NUMBER(38) | NO | The statistics ID. |
| VALUE | NUMBER(38) | YES | The value of the statistics. |
Sample query
Query the details of system statistics for the current tenant and display the first record.
obclient [SYS]> SELECT * FROM SYS.DBA_WR_SYSSTAT WHERE ROWNUM <= 1\G
The returned result is as follows:
*************************** 1. row ***************************
CLUSTER_ID: 10001
TENANT_ID: 1004
SNAP_ID: 1331
SVR_IP: xx.xx.xx.xx
SVR_PORT: 28825
STAT_ID: 10000
VALUE: 53915269
1 row in set (0.063 sec)