How to find out which transaction consumes most of the rollback segment?
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?
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;
Try hard to get what you like OR you will be forced to like what you get.
Rollback segments with an undo tablespace? Undo segments, yes, rollback segments, no.
Click Here to Expand Forum to Full Width