set linesize 130;
PROMPT Shows users and the rollback segments they are using.
COL username FORM A10;
COL machine  FORM A20;

SELECT username,s.machine,s.osuser,r.name, s.sid
FROM v$transaction t, v$rollname r, v$session s
WHERE t.addr = s.taddr
AND t.xidusn=r.usn;

