V$STATISTICS_LEVEL

最新推荐文章于 2016-06-29 04:08:54 发布

EVISWANG

最新推荐文章于 2016-06-29 04:08:54 发布

阅读量525

点赞数

分类专栏： v$ package

本文链接：https://blog.csdn.net/EVISWANG/article/details/50382592

版权

9 篇文章 0 订阅

订阅专栏

V$STATISTICS_LEVEL displays the status of the statistics/advisories controlled by STATISTICS_LEVEL.

Column	Datatype	Description
`STATISTICS_NAME`	`VARCHAR2(64)`	Name of the statistic/advisory
`DESCRIPTION`	`VARCHAR2(4000)`	Description of the statistic/advisory
`SESSION_STATUS`	`VARCHAR2(8)`	Status of the statistic/advisory for the session: `ENABLED` `DISABLED`
`SYSTEM_STATUS`	`VARCHAR2(8)`	System-wide status of the statistic/advisory: `ENABLED` `DISABLED`
`ACTIVATION_LEVEL`	`VARCHAR2(7)`	Indicates the level of `STATISTICS_LEVEL` that enables the statistic/advisory: `BASIC` `TYPICAL` `ALL`
`STATISTICS_VIEW_NAME`	`VARCHAR2(64)`	If there is a single view externalizing the statistic/advisory, then this column contains the name of that view. If there is no such view, then this column is null. If there are multiple views involved, then the`DESCRIPTION` column mentions the view names.
`SESSION_SETTABLE`	`VARCHAR2(3)`	Indicates whether the statistic/advisory can be set at the session level (`YES`) or not (`NO`)

statistics_level 参数是oracle9.2开始引入的一个控制系统统计参数收集的一个开关.

一共有三个值:basic,typical,all.支持alter session,alter system 动态修改.

如果要用statspack或者AWR收集系统性能统计数据.那么这个参数的值必须为typical或all.

通常all是一个全面收集,包括 OS以及sql执行路径方面的一些统计信息,除非遇见非常严重的

性能问题或在一些特殊的性能挣断方面才会用到statistics_level=all,

平常statistics_level=typeical已经足够挣断99%的性能问题了.

关注