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 | 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. |
| NAME | VARCHAR2(64) | Statistic name |
| CLASS | NUMBER | A number representing one or more statistics class. The following class numbers are additive:
|
| VALUE | NUMBER | Statistic value |
| STAT_ID | NUMBER |
Identifier of the statistic |
1、name表示statistics的名称，这列很重要，因为要从这列中找到统计信息表达的含义。
2、value表示统计信息的值。
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23655288/viewspace-718367/ ，如需转载，请注明出处，否则将追究法律责任。
