COL NAME FORMAT A10
SET LINESIZE 100
SELECT 
ROWNUM , 
SYS .DBA_ROLLBACK_SEGS.SEGMENT_NAME NAME , 
V$ROLLSTAT.EXTENTS EXTENTS , 
V$ROLLSTAT.RSSIZE SIZE_IN_BYTES, 
V$ROLLSTAT.XACTS XACTS, V$ROLLSTAT.GETS GETS, 
V$ROLLSTAT.WAITS WAITS, 
V$ROLLSTAT.WRITES WRITES, 
SYS .DBA_ROLLBACK_SEGS.STATUS STATUS 
FROM V$ROLLSTAT, SYS .DBA_ROLLBACK_SEGS, V$ROLLNAME 
WHERE V$ROLLNAME.NAME (+) = SYS .DBA_ROLLBACK_SEGS.SEGMENT_NAME 
AND V$ROLLSTAT.USN (+) = V$ROLLNAME.USN ORDER BY ROWNUM ; 

版权声明：本文为博主原创文章，未经博主允许不得转载。