DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Rollback Transactions

  1. #1
    Join Date
    Feb 2000
    Location
    Alexandria, VA, 22314
    Posts
    41
    How do I find what transactions (SQL Statement, USER) are accessing a ROLLBACK Segment?

    Thanks,

    Keith

  2. #2
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    use some variation of
    select s.sid, s.osuser, s.username,r.usn, r.name rollback_seg, t.used_ublk,
    stat.rssize/blocksize RBS_BLKS
    from v$session s, v$transaction t, v$rollname r, v$rollstat stat
    , (select bytes/blocks blocksize from sys.dba_segments where rownum=1)
    where s.taddr(+) =t.addr and t.xidusn(+) = r.usn and r.usn = stat.usn(+)
    order by r.name;

    (Oracle 8i)

    d.

    p.s. you could also use
    (select value blocksize from v$parameter where name ='db_block_size')
    to get the blocksize instead of using sys.dba_segments in-line query.

    [Edited by DBAtrix on 02-12-2001 at 11:10 AM]

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