`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 |