Note
Introduced in version 1.4.
Description
The V$SYSSTAT view displays the system-level statistical events on the current server.
Each row in the view corresponds to a statistical event. The columns are described as follows:
- STATISTIC# : the index of the statistical event. The index of the same statistical event may vary across OBServer nodes of different versions.
- STAT_ID : the ID of the statistical event. The ID of the same statistical event is the same on all OBServer nodes of all versions.
Note
To query the V$SYSSTAT view, set the enable_perf_event parameter to True.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| CON_ID | NUMBER | NO | Tenant ID |
| SVR_IP | VARCHAR2(46) | NO | IP address of the server where the data is located |
| SVR_PORT | NUMBER(38) | NO | Port number of the server where the data is located |
| STATISTIC# | NUMBER | NO | Index of the statistical event |
| NAME | VARCHAR2(64) | NO | Name of the statistical event |
| CLASS | NUMBER | NO | Type to which the statistical event belongs |
| VALUE | NUMBER | NO | Result value of the statistical event |
| STAT_ID | NUMBER | NO | ID of the statistical event |