Oracle Tips by Burleson
Chapter 6 Oracle Tablespace and File
FORMAT 999999 HEADING "Current|Extent"
curblk FORMAT 999999 HEADING "Current|Block"
COLUMN transaction FORMAT A15 Heading 'Transaction'
COLUMN program FORMAT a10 HEADING 'Program'
SET PAGES 56 LINES 80 VERIFY OFF FEEDBACK OFF
ttitle "Rollback Segments in Use"
NVL(p.username, 'no transaction') "Transaction",
SEE CODE DEPOT FOR FULL SCRIPT
priced his collection of scripts at $49.95, less than a dime per
script. You can download them immediately at this link: