Time Model Statistics

tsinglee發表於2008-05-28

可從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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章