How much rollback segment used at particular time..?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: How much rollback segment used at particular time..?

  1. #1
    Join Date
    Jul 2002
    Posts
    205
    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.

    Thanks..

    skdas

  2. #2
    Join Date
    Oct 2000
    Posts
    449
    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