Overview
The V$SESSTAT view displays statistics on events at the session level.
Columns
Field |
Type |
Nullable |
Description |
|---|---|---|---|
| SID | bigint(20) | NO |
|
| CON_ID | bigint(20) | NO | Tenant ID |
| SVR_IP | varchar(46) | NO | IP Address of the Server Where Information is Located |
| SVR_PORT | bigint(20) | NO | Port number of the server where the information is located |
| STATISTICS# | bigint(20) | NO | Index of the statistical event |
| VALUE | bigint(20) | NO | Count of Occurrences |
Sample query
Query the overview of statistical events at the session level.
obclient [oceanbase]> SELECT * FROM oceanbase.V$SESSTAT LIMIT 1\G
The query result is as follows:
*************************** 1. row ***************************
SID: 3221696264
CON_ID: 1
SVR_IP: xx.xx.xx.xx
SVR_PORT: 2882
STATISTIC#: 0
VALUE: 0