v$mystat
V$MYSTAT
This view contains statistics on the current session.
V$MYSTAT
This view contains statistics on the current session.
Column | Datatype | Description |
|
| ID of the current session |
|
| Number of the statistic |
|
| Value of the statistic |
V$SESSTAT
This view lists user session statistics. To find the name of the statistic associated with each statistic number (STATISTIC#), query the V$STATNAME view.
Column | Datatype | Description |
|
| Session identifier |
|
| Statistic number (identifier) 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. |
|
| Statistic value |
V$SYSSTAT
This view lists system statistics. To find the name of the statistic associated with each statistic number (STATISTIC#), query the V$STATNAME view.
Column | Datatype | Description |
|
| 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. |
|
| Statistic name |
|
| A number representing one or more statistics class. The following class numbers are additive:
|
|
| Statistic value |
V$STATNAME
This view displays decoded statistic names for the statistics shown in the V$SESSTAT and V$SYSSTAT tables.
On some platforms, the NAME and CLASS columns contain additional operating system-specific statistics.
Column | Datatype | Description |
|
| 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. |
|
| Statistic name |
|
| A number representing one or more statistics classes. The following class numbers are additive:
|
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/8394333/viewspace-987133/ ，如需转载，请注明出处，否则将追究法律责任。
