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

Thread: Rollback Segments for Transaction

  1. #1

    Cool

    How could I know which rollback segment is being used by the current or a specified transaction?
    Queyon Zeng

  2. #2
    Join Date
    Sep 2000
    Posts
    384
    select substr(a.os_user_name,1,8) "OS User"
    , substr(a.oracle_username,1,8) "DB User"
    , substr(b.owner,1,8) "Schema"
    , substr(b.object_name,1,20) "Object Name"
    , substr(b.object_type,1,10) "Type"
    , substr(c.segment_name,1,5) "RBS"
    , substr(d.used_urec,1,12) "# of Records"
    from v$locked_object a
    , dba_objects b
    , dba_rollback_segs c
    , v$transaction d
    , v$session e
    where a.object_id = b.object_id
    and a.xidusn = c.segment_id
    and a.xidusn = d.xidusn
    and a.xidslot = d.xidslot
    and d.addr = e.taddr;
    Radhakrishnan.M

  3. #3

    Wink Thanks a lot

    Thank you.
    Queyon Zeng

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