8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | 23c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux
Script: rbs_stats.sql
( Download Script )
-- ----------------------------------------------------------------------------------- -- File Name : https://oracle-base.com/dba/monitoring/rbs_stats.sql -- Author : Tim 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