Note
This view is available starting with V1.4.
Purpose
This view displays some session-level statistics of the current tenant on the current OBServer node. STATISTIC# indicates the statistic item number. You can query the V$STATNAME view to obtain the name and description of the statistic item corresponding to the statistic item number.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SID | NUMBER | NO | For V4.2.x:
|
| CON_ID | NUMBER | NO | Tenant ID |
| SVR_IP | VARCHAR2(46) | NO | Server IP address |
| SVR_PORT | NUMBER(38) | NO | Server port number |
| STATISTIC# | NUMBER | NO | Statistic item number |
| VALUE | NUMBER | NO | Statistic item value |
Sample query
Query the session-level statistics of the current tenant on the current OBServer node in the user tenant, and display the first 10 records.
obclient [SYS]> SELECT * FROM SYS.V$SESSTAT WHERE ROWNUM <= 10;
The query result is as follows:
+----------------------+--------+----------------+----------+------------+-------+
| SID | CON_ID | SVR_IP | SVR_PORT | STATISTIC# | VALUE |
+----------------------+--------+----------------+----------+------------+-------+
| -9223372036854723788 | 1004 | 11.xxx.xxx.xxx | 28825 | 0 | 0 |
| -9223372036854723788 | 1004 | 11.xxx.xxx.xxx | 28825 | 2 | 0 |
| -9223372036854723788 | 1004 | 11.xxx.xxx.xxx | 28825 | 129 | 0 |
| -9223372036854723788 | 1004 | 11.xxx.xxx.xxx | 28825 | 130 | 0 |
| -9223372036854723788 | 1004 | 11.xxx.xxx.xxx | 28825 | 161 | 0 |
| -9223372036854723788 | 1004 | 11.xxx.xxx.xxx | 28825 | 162 | 0 |
| -9223372036854723788 | 1004 | 11.xxx.xxx.xxx | 28825 | 163 | 0 |
| -9223372036854723788 | 1004 | 11.xxx.xxx.xxx | 28825 | 164 | 0 |
| -9223372036854723788 | 1004 | 11.xxx.xxx.xxx | 28825 | 165 | 0 |
| -9223372036854723788 | 1004 | 11.xxx.xxx.xxx | 28825 | 166 | 0 |
+----------------------+--------+----------------+----------+------------+-------+
10 rows in set
References
Query the tenant-level statistics:
- For more information about the statistics, see Common statistics.