René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

Tracking undo generated by session

The following statement displays a record for all sessions that have generated undo. It shows both how many undo blocks and undo records a session made.
select
   s.sid, 
   s.username,
   r.name       "RBS name", 
   t.start_time,
   t.used_ublk  "Undo blocks",
   t.used_urec  "Undo recs"
 from
   v$session s,
   v$transaction t,
   v$rollname r
 where
   t.addr = s.taddr and
   r.usn  = t.xidusn;