-
How to find out which transaction consumes most of the rollback segment?
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
-
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,
Vijay Tummala
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|