TIMED_STATISTICS

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

原创最新推荐文章于 2024-11-19 16:52:48 发布 · 594 阅读

0 ·

CC 4.0 BY-SA版权

做程序员时积累的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.