How to find out which transaction consumes most of the rollback segment?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

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

  1. #1
    Join Date
    Jan 2003
    Location
    hong kong
    Posts
    29

    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

  2. #2
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    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.

  3. #3
    Join Date
    May 2002
    Posts
    2,645
    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
  •  



Click Here to Expand Forum to Full Width