How to find out which transaction consumes most of the rollback segment?

[cleegt]

Dear All,

One of my databases 's undo tabelspace is close to full. I need to find out which transaction is taking most of the undo tablespace. Is there any way that I can find out how much of rollback segment that a transaction has consumed?

Regards,

-- Chris

[vnktummala]

below query might help you ...

SELECT a.sid, a.username, b.xidusn, b.used_urec, b.used_ublk FROM
v$session a, v$transaction b WHERE a.saddr = b.ses_addr;

Regards,

[stecal]

Rollback segments with an undo tablespace? Undo segments, yes, rollback segments, no.