ITPub博客

首页 > 应用开发 > Java > script--by Steve Adams

script--by Steve Adams

原创 Java 作者:OmarChina 时间:2007-10-22 23:35:50 0 删除 编辑
-- Script: routine_waits.sql
-- Purpose: to show the average wait time of routine waits[@more@]

-------------------------------------------------------------------------------
--
-- Script: routine_waits.sql
-- Purpose: to show the average wait time of routine waits
--
-- Copyright: (c) 1998 Ixora Pty Ltd
-- Author: Steve Adams
--
-------------------------------------------------------------------------------
@reset_sqlplus

column average_wait format 9999990.00

select
substr(e.event, 1, 40) event,
e.average_wait
from
sys.v_$system_event e,
sys.v_$instance i
where
e.event = 'DFS lock handle' or
e.event = 'rdbms ipc reply' or
e.event like 'SQL*Net%to%' or
e.event like 'db file%' or
e.event like 'direct path%' or
e.event like 'global cache lock % to %' or
e.event like 'global cache lock open %' or
( e.event like 'log file%' and
e.event not like 'log file switch%'
) or
( e.event = 'row cache lock' and
i.parallel = 'YES'
)
/

@reset_sqlplus

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

上一篇: 面试
请登录后发表评论 登录
全部评论
  • 博文量
    68
  • 访问量
    997751