Scripts:查询sga中各组件使用率的脚本perf_sga_usage.sql
来源:互联网 发布:乐高机器人编程视频 编辑:程序博客网 时间:2024/04/29 19:26
-- +----------------------------------------------------------------------------+
-- | Jeffrey M. Hunter |
-- | jhunter@idevelopment.info |
-- | www.idevelopment.info |
-- |----------------------------------------------------------------------------|
-- | Copyright (c) 1998-2011 Jeffrey M. Hunter. All rights reserved. |
-- |----------------------------------------------------------------------------|
-- | DATABASE : Oracle |
-- | FILE : perf_sga_usage.sql |
-- | CLASS : Tuning |
-- | PURPOSE : Report on all components within the SGA. |
-- | 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
SET FEEDBACK off
SET VERIFY off
COLUMN bytes FORMAT 999,999,999
COLUMN percent FORMAT 999.99999
break on report
compute sum of bytes on report
compute sum of percent on report
SELECT
a.name
, a.bytes
, a.bytes/(b.sum_bytes*100) Percent
FROM sys.v_$sgastat a
, (SELECT SUM(value)sum_bytes FROM sys.v_$sga) b
ORDER BY bytes DESC
/
-- | Jeffrey M. Hunter |
-- | jhunter@idevelopment.info |
-- | www.idevelopment.info |
-- |----------------------------------------------------------------------------|
-- | Copyright (c) 1998-2011 Jeffrey M. Hunter. All rights reserved. |
-- |----------------------------------------------------------------------------|
-- | DATABASE : Oracle |
-- | FILE : perf_sga_usage.sql |
-- | CLASS : Tuning |
-- | PURPOSE : Report on all components within the SGA. |
-- | 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
SET FEEDBACK off
SET VERIFY off
COLUMN bytes FORMAT 999,999,999
COLUMN percent FORMAT 999.99999
break on report
compute sum of bytes on report
compute sum of percent on report
SELECT
a.name
, a.bytes
, a.bytes/(b.sum_bytes*100) Percent
FROM sys.v_$sgastat a
, (SELECT SUM(value)sum_bytes FROM sys.v_$sga) b
ORDER BY bytes DESC
/
0 0
- Scripts:查询sga中各组件使用率的脚本perf_sga_usage.sql
- Scripts:查询db_block_buffer使用率的脚本perf_db_block_buffer_usage.sql
- Scripts:查询数据文件IO使用率的脚本 perf_file_io.sql
- sga内各组件的简介
- Scripts:报告sga中空闲内存的情况perf_sga_free_pool.sql
- Scripts:查询等待事件的SQL脚本owi_event_names.sql
- Scripts:查看数据文件使用率的脚本(包括临时表空间的文件哦)dba_file_space_usage.sql
- Scripts:查询log file sync 等待的脚本lfsdiag.sql
- Scripts:查询参数信息的脚本parms.sql
- Scripts:查询所有参数修改信息的脚本parm_mods.sql
- Scripts:查询每个数据文件等待时间的脚本perf_file_waits.sql
- Scripts:查询每个session命中率的脚本perf_hit_ratio_by_session.sql
- Scripts:查询每个数据文件使用效率的脚本perf_file_io_efficiency.sql
- Scripts:查询回滚段信息的脚本rollback_segments.sql
- SQL SERVER 2008 各组件的用途
- Scripts:常用查询数据库中锁的脚本
- hadoop中各组件的作用
- Tinyos-2.1.1中各组件的分布总结(查询)表
- CentOs添加开机重启服务
- 黑客高手是这样上网的!Vimium、Vimperator 浏览器插件让你全程用键盘快捷高效浏览网页
- 时尚的左侧菜单
- ldap的启动问题
- Silverlight MVVM
- Scripts:查询sga中各组件使用率的脚本perf_sga_usage.sql
- 用NSURLConnection Post上传数据的"+"会变成空格
- 在Xcode中使用Git进行源码版本控制
- 如何保护Excel工作表,不被人修改或删除指定区域
- 高斯函数
- 未来三天华北黄淮有高温天气 河北山东局地达40℃
- 精通安卓性能优化-第二章(一)
- 学魅族手滑,中兴红牛V5抢购标错价
- myeclipse搭建Java版WebService(SOAP方式)