latch_holders.sql

oracle dba 常用的管理脚本, 覆盖日常的系统管理.

--* File Name    : Latch_Holders.sql
--* Author       : DR Timothy S Hall
--* Description  : Displays information about all current latch holders.
--* Requirements : Access to the V$ views.
--* Call Syntax  : @Latch_Holders
--* Last Modified: 15/07/2000
SET LINESIZE 500
SET PAGESIZE 1000
SET VERIFY OFF

SELECT a.name "Latch Name",
       b.pid "PID",
       b.sid "SID",
       a.gets "Gets (Wait)",
       a.misses "Misses (Wait)",
       a.sleeps "Sleeps (Wait)",
       a.immediate_gets "Gets (No Wait)",
       a.immediate_misses "Misses (Wait)"
FROM   v$latch a,
       v$latchholder b
WHERE  a.addr = b.laddr
ORDER BY 1;

SET PAGESIZE 14
SET VERIFY ON