--

-- Show undo information.

--

SET PAUSE ON

SET PAUSE 'Press Return to Continue'

SET PAGESIZE 60

SET LINESIZE 300

COLUMN username FORMAT A20

COLUMN sid FORMAT 9999

COLUMN serial# FORMAT 99999

SELECT s.inst_id,

       s.username,

       s.sid,

       s.serial#,

       t.used_ublk,

       t.used_urec,

       rs.segment_name,

       r.rssize,

       r.status

FROM   gv$transaction t,

       gv$session s,

       gv$rollstat r,

       dba_rollback_segs rs

WHERE  s.saddr = t.ses_addr

AND    s.inst_id = t.inst_id

AND    t.xidusn = r.usn

AND    t.inst_id = r.inst_id

AND    rs.segment_id = t.xidusn

ORDER BY t.used_ublk DESC

/