Oracle TIMED_STATISTICS 参数 说明
MOS上有关TIMED_STATISTICS参数说明：
Init.ora Parameter "TIMED_STATISTICS" Reference Note [ID 30824.1]
Health CheckAlert: Consider setting TIMED_STATISTICS and STATISTICS_LEVEL to recommendedlevels [ID 957433.1]
Version | Parameter |
| Type | Modifiable |
11.1.0.7 | timed_statistics | BOOLEAN | ALTER SESSION | |
11.1.0.6 | timed_statistics | BOOLEAN | ALTER SESSION | |
10.2.0.4 | timed_statistics | BOOLEAN | ALTER SESSION | |
10.2.0.3 | timed_statistics | BOOLEAN | ALTER SESSION | |
10.1.0.5 | timed_statistics | BOOLEAN | ALTER SESSION | |
10.1.0.4 | timed_statistics | BOOLEAN | ALTER SESSION | |
9.2.0.8 | timed_statistics | BOOLEAN | ALTER SESSION | |
9.0.1.4 | timed_statistics | BOOLEAN | ALTER SESSION | |
8.1.7.4 | timed_statistics | BOOLEAN | ALTER SESSION |
TIMED_STATISTICSspecifies whether or not statistics related to time are collected. It isimportant to set TIMED_STATISTICS=TRUE for obtaining timing information whichwill help in tuning the database.
--TIMED_STATISTICS 指定是否收集于时间相关的统计信息，当设置为TURE时会获取有关时间的更多信息，从而帮助我们来优化DB.
有如下三种方法来设置该参数：
（1）初始化参数
The parameter can be set in theinitialisation file e.g.
timed_statistics= TRUE
（2）system 级别：
This parameter can be set at system levele.g.
ALTER SYSTEM SETtimed_statistics = TRUE
（3）session 级别：
This parameter can be set at session levele.g.
ALTER SESSION SET timed_statistics = TRUE
When TIMED_STATISTICS is enabled statistics are generated for the following：
（1）PARSE, EXEC and FETCH CPU costs intrace files
（2）V$WAITSTAT
（3）V$FILESTAT and V$TEMPSTAT
（4）V$SYSSTAT and V$SESSTAT timedstatistics
Statistics affected by enabling TIMED_STATISTICS include
|
Wait times arerecorded in V$SESSION_EVENT, V$SYSTEM_EVENT and V$SESSION_WAIT irrespective ofthe setting of TIMED_STATISTICS (9.2.0)
关于该参数的默认值，在官网上有关TIMED_STATISTICS 参数的说明：
http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams255.htm#REFRN10218
If STATISTICS_LEVEL is set to TYPICAL or ALL,then true
If STATISTICS_LEVEL is set to BASIC,then false
如果STATISTICS_LEVEL 设置为TYPICAL或者ALL,那么TIMED_STATISTICS 则默认为true。 如果STATISTICS_LEVEL设置为BASIC，则TIMED_STATISTICS 默认为false。
MOS上对STATISTICS_LEVEL的说明：
STATISTICS_LEVELspecifies the level of collection for the database and operating systemstatistics. The Oracle Database collects these statistics for a variety ofreasons, including making self-management decisions. Setting theSTATISTICS_LEVEL parameter to BASIC disables the collection of many importantstatistics required by Oracle Database features and functionality.STATISTICS_LEVEL=ALL should only be set for diagnostic purposes as required.
有关该参数在之前整理的Blog里有说明：
http://blog.csdn.net/tianlesoftware/article/details/4668723
-------------------------------------------------------------------------------------------------------
版权所有，文章允许转载，但必须以链接方式注明源地址，否则追究法律责任!
Email: tianlesoftware@gmail.com
Skype: tianlesoftware
Blog: http://www.tianlesoftware.com
Weibo: http://weibo.com/tianlesoftware
Twitter: http://twitter.com/tianlesoftware
Facebook:http://www.facebook.com/tianlesoftware
-------加群需要在备注说明Oracle表空间和数据文件的关系，否则拒绝申请----
DBA1 群：62697716(满); DBA2 群：62697977(满) DBA3 群：62697850(满)
DBA 超级群：63306533(满); DBA4 群：83829929 DBA5群： 142216823
DBA6 群：158654907 DBA7 群：172855474
