Scripts:查询每个数据文件等待时间的脚本perf_file_waits.sql
来源:互联网 发布:java抽象类的特点 编辑:程序博客网 时间:2024/05/16 07:34
-- +----------------------------------------------------------------------------+
-- | Jeffrey M. Hunter |
-- | jhunter@idevelopment.info |
-- | www.idevelopment.info |
-- |----------------------------------------------------------------------------|
-- | Copyright (c) 1998-2011 Jeffrey M. Hunter. All rights reserved. |
-- |----------------------------------------------------------------------------|
-- | DATABASE : Oracle |
-- | FILE : perf_file_waits.sql |
-- | CLASS : Tuning |
-- | PURPOSE : Reports on Busy Buffer Waits per file. |
-- | NOTE : As with any code, ensure to test this script in a development |
-- | environment before attempting to run it in production. |
-- +----------------------------------------------------------------------------+
SET LINESIZE 145
SET PAGESIZE 9999
COLUMN filename FORMAT a58 HEAD "File Name"
COLUMN file# FORMAT 999 HEAD "File #"
COLUMN ct FORMAT 999,999,999 HEAD "Waits (count)"
COLUMN time FORMAT 999,999,999 HEAD "Time (cs)"
COLUMN avg FORMAT 999.999 HEAD "Avg Time"
SELECT
a.indx + 1 file#
, b.name filename
, a.count ct
, a.time time
, a.time/(DECODE(a.count,0,1,a.count)) avg
FROM
x$kcbfwait a
, v$datafile b
WHERE
indx < (SELECT count(*) FROM v$datafile)
AND a.indx+1 = b.file#
ORDER BY a.time
/
-- | Jeffrey M. Hunter |
-- | jhunter@idevelopment.info |
-- | www.idevelopment.info |
-- |----------------------------------------------------------------------------|
-- | Copyright (c) 1998-2011 Jeffrey M. Hunter. All rights reserved. |
-- |----------------------------------------------------------------------------|
-- | DATABASE : Oracle |
-- | FILE : perf_file_waits.sql |
-- | CLASS : Tuning |
-- | PURPOSE : Reports on Busy Buffer Waits per file. |
-- | NOTE : As with any code, ensure to test this script in a development |
-- | environment before attempting to run it in production. |
-- +----------------------------------------------------------------------------+
SET LINESIZE 145
SET PAGESIZE 9999
COLUMN filename FORMAT a58 HEAD "File Name"
COLUMN file# FORMAT 999 HEAD "File #"
COLUMN ct FORMAT 999,999,999 HEAD "Waits (count)"
COLUMN time FORMAT 999,999,999 HEAD "Time (cs)"
COLUMN avg FORMAT 999.999 HEAD "Avg Time"
SELECT
a.indx + 1 file#
, b.name filename
, a.count ct
, a.time time
, a.time/(DECODE(a.count,0,1,a.count)) avg
FROM
x$kcbfwait a
, v$datafile b
WHERE
indx < (SELECT count(*) FROM v$datafile)
AND a.indx+1 = b.file#
ORDER BY a.time
/
0 0
- Scripts:查询每个数据文件等待时间的脚本perf_file_waits.sql
- Scripts:查询每个数据文件使用效率的脚本perf_file_io_efficiency.sql
- Scripts:查询数据文件IO使用率的脚本 perf_file_io.sql
- Scripts:查询每个session命中率的脚本perf_hit_ratio_by_session.sql
- Scripts:查询等待事件的SQL脚本owi_event_names.sql
- Scripts:查询log file sync 等待的脚本lfsdiag.sql
- Scripts:查询db_block_buffer使用率的脚本perf_db_block_buffer_usage.sql
- Scripts:查询参数信息的脚本parms.sql
- Scripts:查询所有参数修改信息的脚本parm_mods.sql
- Scripts:查询回滚段信息的脚本rollback_segments.sql
- Scripts:查看数据文件使用率的脚本(包括临时表空间的文件哦)dba_file_space_usage.sql
- Scripts:报告物理数据库增长情况(注意脚本是看你数据库添加数据文件的时间哦)dba_db_growth.sql
- Scripts:查询物理读最多的10个SQL的脚本hphy10.sql
- Scripts:列出用户信息的脚本sec_users.sql
- Scripts:查询library cache lock和hang的脚本library_cache_locks_pins.sql
- Scripts:根据sid,ospid来查询进程信息的脚本os_pid.sql
- Scripts:查询sga中各组件使用率的脚本perf_sga_usage.sql
- EBS查询sql scripts
- Scripts:查询所有参数修改信息的脚本parm_mods.sql
- 书本Applet程序练习------同一页Applet之间的通信
- NYOJ 题目79 拦截导弹
- 新辰:90后大学生创业开口笑馒头店火爆全市 卖馒头日赚2000!
- Scripts:查询数据文件IO使用率的脚本 perf_file_io.sql
- Scripts:查询每个数据文件等待时间的脚本perf_file_waits.sql
- 游起来吧!超妹!(物理小试题)
- Scripts:查询每个session命中率的脚本perf_hit_ratio_by_session.sql
- Object C Lesson1
- Android Activity布局之RelativeLayout
- Scripts:查询每个数据文件使用效率的脚本perf_file_io_efficiency.sql
- 终于理解动态规划,最简单运用~
- java的几种对象(PO,VO,DAO,BO,POJO)解释
- hdu 2112 HDU Today (dijkstra)