Scripts:perf_redo_log_contention.sql
来源:互联网 发布:如何上淘宝开发票抬头 编辑:程序博客网 时间:2024/04/29 12:11
-- +----------------------------------------------------------------------------+
-- | Jeffrey M. Hunter |
-- | jhunter@idevelopment.info |
-- | www.idevelopment.info |
-- |----------------------------------------------------------------------------|
-- | Copyright (c) 1998-2011 Jeffrey M. Hunter. All rights reserved. |
-- |----------------------------------------------------------------------------|
-- | DATABASE : Oracle |
-- | FILE : perf_redo_log_contention.sql |
-- | CLASS : Tuning |
-- | PURPOSE : Report on overall redo log contention for the instance since |
-- | the instance was last started. |
-- | 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 VERIFY off
prompt
prompt =======================================
prompt Latches
prompt =======================================
prompt
COLUMN name FORMAT a30 HEADING 'Latch Name'
COLUMN gets FORMAT 999,999,999 HEADING 'Gets'
COLUMN misses FORMAT 999,999,999 HEADING 'Misses'
COLUMN sleeps FORMAT 999,999,999 HEADING 'Sleeps'
COLUMN immediate_gets FORMAT 999,999,999 HEADING 'Immediate Gets'
COLUMN immediate_misses FORMAT 999,999,999 HEADING 'Immediate Misses'
BREAK ON report
COMPUTE SUM OF gets ON report
COMPUTE SUM OF misses ON report
COMPUTE SUM OF sleeps ON report
COMPUTE SUM OF immediate_gets ON report
COMPUTE SUM OF immediate_misses ON report
SELECT
INITCAP(name) name
, gets
, misses
, sleeps
, immediate_gets
, immediate_misses
FROM sys.v_$latch
WHERE name LIKE 'redo%'
ORDER BY 1;
prompt
prompt =======================================
prompt System Statistics
prompt =======================================
prompt
COLUMN name FORMAT a30 HEADING 'Statistics Name'
COLUMN value FORMAT 999,999,999,999 HEADING 'Value'
SELECT
name
, value
FROM
v$sysstat
WHERE
name LIKE 'redo%';
-- | Jeffrey M. Hunter |
-- | jhunter@idevelopment.info |
-- | www.idevelopment.info |
-- |----------------------------------------------------------------------------|
-- | Copyright (c) 1998-2011 Jeffrey M. Hunter. All rights reserved. |
-- |----------------------------------------------------------------------------|
-- | DATABASE : Oracle |
-- | FILE : perf_redo_log_contention.sql |
-- | CLASS : Tuning |
-- | PURPOSE : Report on overall redo log contention for the instance since |
-- | the instance was last started. |
-- | 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 VERIFY off
prompt
prompt =======================================
prompt Latches
prompt =======================================
prompt
COLUMN name FORMAT a30 HEADING 'Latch Name'
COLUMN gets FORMAT 999,999,999 HEADING 'Gets'
COLUMN misses FORMAT 999,999,999 HEADING 'Misses'
COLUMN sleeps FORMAT 999,999,999 HEADING 'Sleeps'
COLUMN immediate_gets FORMAT 999,999,999 HEADING 'Immediate Gets'
COLUMN immediate_misses FORMAT 999,999,999 HEADING 'Immediate Misses'
BREAK ON report
COMPUTE SUM OF gets ON report
COMPUTE SUM OF misses ON report
COMPUTE SUM OF sleeps ON report
COMPUTE SUM OF immediate_gets ON report
COMPUTE SUM OF immediate_misses ON report
SELECT
INITCAP(name) name
, gets
, misses
, sleeps
, immediate_gets
, immediate_misses
FROM sys.v_$latch
WHERE name LIKE 'redo%'
ORDER BY 1;
prompt
prompt =======================================
prompt System Statistics
prompt =======================================
prompt
COLUMN name FORMAT a30 HEADING 'Statistics Name'
COLUMN value FORMAT 999,999,999,999 HEADING 'Value'
SELECT
name
, value
FROM
v$sysstat
WHERE
name LIKE 'redo%';
0 0
- Scripts:perf_redo_log_contention.sql
- Common SQL Scripts
- Workflow SQL scripts安装
- EBS查询sql scripts
- Scripts in $AD_TOP/sql
- Scripts:perf_performance_snapshot.sql
- Scripts:segment_size.sql
- Scripts:sess_users_by_cursors.sql
- Scripts:sess_users_by_cpu.sql
- Scripts:sess_users_active_sql.sql
- Scripts:sess_users_active.sql
- Scripts:sess_users_by_transactions.sql
- Scripts:sess_users_by_memory.sql
- Scripts:sess_users_by_io.sql
- Scripts:session_wait.sql
- Scripts:sess_waiting.sql
- Scripts:top.sql
- Scripts:sqlhc.sql
- 使程序在Linux下后台运行
- c语言中 #define 和#ifdef 用法
- IIS7 中设置浏览器缓存
- DsstrEntity is not mapped 和 No identifier specified for entity:
- 手机上安装同一android应用的不同版本
- Scripts:perf_redo_log_contention.sql
- 机器人 串口配置文件serial.INI
- 用OpenSceneGraph实现的NeHe OpenGL教程 - 第三十二课
- CFile 深入研究之 CFile::modeNoTruncate
- 科普贴:那些知名的大型开源会议(二)
- Scripts:perf_performance_snapshot.sql
- UICollectionView介绍
- Spring3所需要的jar包
- 微信限制好友数量,你还微信营销不?