Time Model Statistics

可从V$SESS_TIME_MODEL或者V$SYS_TIME_MODEL动态视图中获得时间类指标的统计数据.

V$SESS_TIME_MODEL displays the session-accumulated time for various operations.
The time reported is the total elapsed or CPU time (in microseconds). Any timed
operation will buffer at most 5 seconds of time data. Specifically, this means that if a
timed operation (such as SQL execution) takes a long period of time to perform, the
data published to this view is at most missing 5 seconds of the time accumulated for
the operation.

The time values are 8-byte integers and can therefore hold approximately 580,000
years of time before wrapping. Background process time is not included in a statistic
value unless the statistic is specifically for background processes.

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-1004777/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-1004777/