可从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.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10599713/viewspace-1004777/ ，如需转载，请注明出处，否则将追究法律责任。
-
博文量740
-
访问量2002848
最新文章
- 人力&人手&人才&人物
- oracle树中prior的用法
- Using Supplied Packages to Manage Stored Outlines
- $ORACLE_HOMERDBMSADMIN目录下各SQL的含义
- PRODUCT_USER_PROFILE Table
- Backing Up Server Parameter Files with RMAN
- Backing Up Control Files with RMAN
- Backing Up Individual Tablespaces with RMAN
- Making Whole Database Backups with RMAN
- 目睹奥运火炬传递
