原创 2004年10月12日 11:54:00
V$SYSTEM_EVENT shows the total number of waits and timeouts, and the total
waiting time recorded for each type of event, accumulated for all processes over
the life of the instance. It is normal to order the events waited for in descending
order of the total time waited, as an indicator of the potential severity of each
type of wait.
However, the total time waited is really only meaningful for those that indicate
waiting for resources. If processes have been waiting because they have no work
to do, then the time waited is immaterial. If they have been waiting for routine
operations, such as disk I/O, then the total time waited will depend on the
workload. In such cases, the average time waited is much more interesting than
the total time waited.
This classification of wait types into idle waits, routine waits, and resource waits
is vital to a correct understanding of the wait statistics. Accordingly, APT has
separate scripts for resource waits and routine waits, and ignores idle waits
altogether. The routine_waits.sql script shows only the average time waited for
each type of routine wait. The resource_waits.sql script (see Example 2.1) shows
the types of resources waited for in descending order of the total time waited, but
also shows the average time waited.


-- Script:	resource_waits.sql
-- Purpose:	to show the total waiting time for resource types
-- Copyright:	(c) 1998 Ixora Pty Ltd
-- Author:	Steve Adams

column average_wait format 9999990.00

  substr(e.event, 1, 40)  event,
  e.time_waited / (
    e.total_waits - decode(e.event, 'latch free', 0, e.total_timeouts)
  )  average_wait
  sys.v_$system_event  e,
  sys.v_$instance  i
  e.event = 'buffer busy waits' or
  e.event = 'enqueue' or
  e.event = 'free buffer waits' or
  e.event = 'global cache freelist wait' or
  e.event = 'latch free' or
  e.event = 'log buffer space' or
  e.event = 'parallel query qref latch' or
  e.event = 'pipe put' or
  e.event = 'write complete waits' or
  e.event like 'library cache%' or
  e.event like 'log file switch%' or
  ( e.event = 'row cache lock' and
    i.parallel = 'NO'
union all
  'non-routine log file syncs',
  round(e.average_wait * greatest(e.total_waits - s.value, 0)),
  sys.v_$system_event e,
  sys.v_$sysstat s
  e.event = 'log file sync' and
  s.name = 'user commits'
order by
  2 desc

-- Script:	reset_sqlplus.sql
-- Purpose:	to reset sqlplus settings
-- Copyright:	(c) 1998 Ixora Pty Ltd
-- Author:	Steve Adams

clear breaks
clear columns
clear computes
set feedback off
set verify off

资料来源:Oracle8i Internal Services


处理器的指令架构,如IA-32、IA一64、x86-32、x86-64。 处理器的指令执行方式,如RISC(精简指令运算集 )、CISC(复杂指令运算集 )、VLIW(显式并行指令运算集 )、EPIC...
  • changyanmanman
  • changyanmanman
  • 2014年03月31日 16:04
  • 1408

Oracle V$SYSTEM_EVENT字段等解释

Oracle V$SYSTEM_EVENT V$SYSTEM_EVENT V$SYSTEM_EVENT displaysinformation on total waits...
  • haiross
  • haiross
  • 2014年12月31日 13:38
  • 2780


--通过v$session和v$session_wait_class,v$system_event,v$event_histogram来确定锁等待--1  获取等待时间select sid,usern...
  • soulcq
  • soulcq
  • 2010年04月02日 11:42
  • 3594


V$SYSTEM_EVENT V$SYSTEM_EVENT显示有关事件总等待的信息。 请注意,在不支持快速计时机制的平台上,TIME_WAITED和AVERAGE_WAIT列将包含零值。如果您正在其...
  • qq_38626217
  • qq_38626217
  • 2017年05月09日 15:43
  • 136


v$system_event: v$system_event 提供了自实例启动后各个等待事件的概括。 SQL> desc v$system_event Name ...
  • zq9017197
  • zq9017197
  • 2011年12月05日 16:29
  • 2425


V$SYSTEM_WAIT_CLASS View This V$SYSTEM_WAIT_CLASS shows the instance-level total waits and time wai...
  • dbcommando
  • dbcommando
  • 2012年06月10日 23:49
  • 1858


1、v$system_event 内容:统计数据,统计instance启动以来每种等待时间的等待次数、时间、平均时间等 目的:用来发现系统级评瓶颈  SQL> desc v$system_eve...
  • duqiangatom
  • duqiangatom
  • 2012年12月17日 19:43
  • 203

Oracle OWI 等待事件视图(v$session_wait/v$session_event/v$system_event)

  • robinson_0612
  • robinson_0612
  • 2013年04月16日 10:00
  • 6906

DBA_Oracle Event等待事件分析(概念)

一、摘要 Oracle的等待事件是衡量Oracle运行状况的重要依据及指标。 等待事件的概念是在Oracle7.0.1.2中引入的,大致有100个等待事件。 在Oracle 8.0中这个数目...
  • p6620582
  • p6620582
  • 2016年09月09日 14:09
  • 1165


本文较为详细的分析了C#中sleep和wait的区别。分享给大家供大家参考。具体分析如下: sleep和wait都是使线程暂时停止执行的方法,但它们有很大的不同。 ①. sleep是线程类...
  • u012252959
  • u012252959
  • 2016年03月13日 10:37
  • 1088