ITPub博客

首页 > Linux操作系统 > Linux操作系统 > v$system_event解析

v$system_event解析

原创 Linux操作系统 作者:lfree 时间:2007-05-12 00:00:00 0 删除 编辑

http://www.adp-gmbh.ch/ora/misc/dynamic_performance_views.html#system_event

v$system_event

This view displays the count (total_waits) of all wait events since startup of the instance.
If timed_statistics is set to true, the sum of the wait times for all events are also displayed in the column time_waited.
The unit of time_waited is one hundreth of a second. Since 10g, an additional column (time_waited_micro) measures wait times in millionth of a second.
total_waits where event='buffer busy waits' is equal the sum of count in v$waitstat.
v$enqueue_stat can be used to break down waits on the enqueue wait event.
While this view totals all events in an instance, v$session_event breaks it down to all currently connected sessions.

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

上一篇: V$SQLAREA解析
下一篇: gvim 7.1 is out
请登录后发表评论 登录
全部评论
熟悉oracle相关技术,擅长sql优化,rman备份与恢复,熟悉linux shell编程。

注册时间:2008-01-03

  • 博文量
    2445
  • 访问量
    6239813