TIMED_STATISTICS

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

 

TIMED_STATISTICS

 

Property	Description
Parametertype	Boolean
Defaultvalue	IfSTATISTICS_LEVEL is set to TYPICAL orALL, 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.