Note
This view is available starting with V1.4.
Purpose
This view displays statistical events for the current tenant across all OBServer nodes.
Here are some details:
STATISTIC#: The index of the statistical item. This value may vary across different OBServer node versions.STAT_ID: The ID of the statistical item. This value is guaranteed to be the same across different OBServer node versions.
Note
To query this view, ensure that monitoring is enabled by setting the enable_perf_event parameter to True.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| CON_ID | NUMBER | NO | The tenant ID. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the server where the information resides. |
| SVR_PORT | NUMBER(38) | NO | The port number of the server where the information resides. |
| STATISTIC# | NUMBER | NO | The index of the statistical event. |
| NAME | VARCHAR2(64) | NO | The name of the statistical event. |
| CLASS | NUMBER | NO | The type of the statistical event. |
| VALUE | NUMBER | NO | The numerical result of the statistical event. |
| STAT_ID | NUMBER | NO | The ID of the statistical event. |
Sample query
Query the statistical events for the current tenant across all nodes and display the first 10 records.
obclient [SYS]> SELECT * FROM SYS.GV$SYSSTAT WHERE ROWNUM <= 10;
The query result is as follows:
+--------+----------------+----------+------------+-----------------------+-------+------------+---------+
| CON_ID | SVR_IP | SVR_PORT | STATISTIC# | NAME | CLASS | VALUE | STAT_ID |
+--------+----------------+----------+------------+-----------------------+-------+------------+---------+
| 1004 | 11.xxx.xxx.xxx | 28825 | 0 | rpc packet in | 1 | 11544765 | 10000 |
| 1004 | 11.xxx.xxx.xxx | 28825 | 1 | rpc packet in bytes | 1 | 4330653649 | 10001 |
| 1004 | 11.xxx.xxx.xxx | 28825 | 2 | rpc packet out | 1 | 23087847 | 10002 |
| 1004 | 11.xxx.xxx.xxx | 28825 | 3 | rpc packet out bytes | 1 | 6688319626 | 10003 |
| 1004 | 11.xxx.xxx.xxx | 28825 | 4 | rpc deliver fail | 1 | 0 | 10004 |
| 1004 | 11.xxx.xxx.xxx | 28825 | 5 | rpc net delay | 1 | 737646453 | 10005 |
| 1004 | 11.xxx.xxx.xxx | 28825 | 6 | rpc net frame delay | 1 | 2067679 | 10006 |
| 1004 | 11.xxx.xxx.xxx | 28825 | 7 | mysql packet in | 1 | 315 | 10007 |
| 1004 | 11.xxx.xxx.xxx | 28825 | 8 | mysql packet in bytes | 1 | 26499 | 10008 |
| 1004 | 11.xxx.xxx.xxx | 28825 | 9 | mysql packet out | 1 | 37214 | 10009 |
+--------+----------------+----------+------------+-----------------------+-------+------------+---------+
10 rows in set
References
To query session-level statistical events:
To query the definitions of all statistical events for the tenant: V$STATNAME
For more information about statistical events, see Commonly Used Statistical Events.