TIMED_STATISTICS

最新推荐文章于 2024-11-19 16:52:48 发布

甲骨文可乐

最新推荐文章于 2024-11-19 16:52:48 发布

阅读量596

点赞数

CC 4.0 BY-SA版权

分类专栏：做程序员时积累的Oracle

本文链接：https://blog.youkuaiyun.com/u011316319/article/details/9276885

做程序员时积累的Oracle 专栏收录该内容

154 篇文章

订阅专栏

本文详细介绍了 Oracle 数据库中的 TIMED_STATISTICS 参数。该参数用于控制与时间相关的统计信息的收集，设置为 true 时将收集并记录这些统计信息，而设置为 false 则会避免收集此类数据以减少系统的开销。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

文档地址：http://docs.oracle.com/cd/B19306_01/server.102/b14237/initparams216.htm#REFRN10218

TIMED_STATISTICS

Property	Description
Parametertype	Boolean
Defaultvalue	If`STATISTICS_LEVEL` is set to `TYPICAL` or`ALL`, then `true` If `STATISTICS_LEVEL` is set to `BASIC`,then `false`
Modifiable	`ALTERSESSION`, `ALTER SYSTEM`
Range ofvalues	`true \|false`

TIMED_STATISTICS specifies whether ornot statistics related to time are collected.

--TIMED_STATISTICS指定与时间相关的统计量是否被收集。

Values:

true

The statistics are collected and stored in trace files ordisplayed in the V$SESSTATS andV$SYSSTATS dynamic performance views.
false

The value of all time-related statistics is set to zero. Thissetting lets Oracle avoid the overhead of requesting the time fromthe operating system. Normally, TIMED_STATISTICSshould be false.

On some systems with very fasttimer access, Oracle might enable timing even if this parameter isset to false. On these systems, setting the parameterto true can sometimes produce more accurate statisticsfor long-running operations.