SET LINES 140 FEED OFF
COL "Tablespace" Format A20
COL "File" Format A40

COL "Segment Name" FORMAT A15
COL "XActs" FORMAT 9999
COL "Next" FORMAT 9999
COL "Next" FORMAT 9999

SELECT
   TO_CHAR(R.SEGMENT_ID, 'fm00') || ' - ' || R.SEGMENT_NAME "Segment Name"
  ,INITCAP( NVL(RS.STATUS, R.STATUS) ) "Status"
  ,RS.XACTS "XActs"
  ,ROUND(RS.RSSIZE/1048576,0) "Allocated"
  ,ROUND(RS.HWMSIZE/1048576,0) "Max Used Size"
  ,ROUND(R.NEXT_EXTENT*R.MAX_EXTENTS/1048576,0) "Limit Size"
  ,RS.EXTENTS "Extents"
  ,R.NEXT_EXTENT/1048576 "Next"
  ,RS.GETS "Gets"
  ,RS.WAITS "Waits"
  ,RS.WRAPS "Wraps"
  ,RS.EXTENDS "Extends"
  ,RS.SHRINKS "Shrinks"
FROM DBA_ROLLBACK_SEGS R, V$ROLLSTAT RS
WHERE R.SEGMENT_ID = RS.USN(+)
ORDER BY "Allocated" Desc
/

SELECT
  TABLESPACE_NAME "Tablespace"
 ,FILE_NAME "File"
 ,BYTES/1048576 "Allocated"
 ,MAXBYTES/1048576 "Limit Size"
 ,INCREMENT_BY*16/1024 "Next"
 ,INITCAP(AUTOEXTENSIBLE) "Ext"
FROM DBA_DATA_FILES
WHERE FILE_NAME LIKE '%rbs%'
/
SET FEED ON