DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Hi ,

    Does any one have any script , to find out how much Rollback segment used by which user, which rollback segment is used, how much space is available etc.



  2. #2
    Join Date
    Oct 2000
    select substr(r.name,1,10) name, r.usn, e.extents, s.sid, substr(s.username,1,10) username, s.logon_time,
    s.status, t.start_time, t.status, t.used_ublk, substr(s.program,1,20) program, s.command
    from v$transaction t ,v$rollname r , v$rollstat e, v$session s
    where r.usn = t.xidusn
    and t.xidusn = e.usn
    and t.addr = s.taddr
    order by r.name

    See v$rollstat to see how extents are used by rssize, hwm and extends.. for active transactions, use xacts > 0

    Thanks, ST2000

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.