V$SESSTAT displays user session statistics. To find the name of the statistic associated with each statistic number (STATISTIC#), query the V$STATNAME view.
| Column | Datatype | Description |
|---|---|---|
SID |
NUMBER |
Session identifier |
STATISTIC# |
NUMBER |
Statistic number
Note: Statistics numbers are not guaranteed to remain constant from one release to another. Therefore, you should rely on the statistics name rather than its number in your applications. |
VALUE |
NUMBER |
Statistic value |