rbs_stats.sql

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

--* File Name    : RBS_Stats.sql
--* Author       : DR Timothy S Hall
--* Description  : Displays rollback segment statistics.
--* Requirements : Access to the v$ & DBA views.
--* Call Syntax  : @RBS_Stats
--* Last Modified: 15/07/2000
SET LINESIZE 500
SET PAGESIZE 1000
SET VERIFY OFF

SELECT b.name "Segment Name",
       Trunc(c.bytes/1024) "Size (Kb)",
       a.optsize "Optimal",
       a.shrinks "Shrinks",
       a.aveshrink "Avg Shrink",
       a.wraps "Wraps",
       a.extends "Extends"
FROM   v$rollstat a,
       v$rollname b,
       dba_segments c
WHERE  a.usn  = b.usn
AND    b.name = c.segment_name
ORDER BY b.name;

SET PAGESIZE 14
SET VERIFY ON