[管理脚本] 回滚段信息

set linesize 200 pagesize 1400;
SELECT
    r.segment_name,
    r.owner,
    r.tablespace_name,
    r.status,
    r.initial_extent/1024 "INITIAL_EXTENT(K)",
    r.next_extent/1024 "NEXT_EXTENT(K)",
    s.extents,
    ROUND(s.rssize/1024) "RSSIZE(K)",
    s.xacts
FROM
    dba_rollback_segs r,
    v$rollname n,
    v$rollstat s
WHERE
    r.segment_name = n.name and n.usn = s.usn
/