SQL quesry and RBS segment
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: SQL quesry and RBS segment

  1. #1
    Join Date
    Jan 2004
    Location
    Washington , USA
    Posts
    132

    SQL quesry and RBS segment

    hi all

    there is one sql file

    it has several inserts , updates, alter , create table,trigger,procedure statements.we have executed this sql by connecting to one schema.

    now want to find out which Query is using what Rollback segment number while it is running ? which view will give me this answer?

    there are 8 rollback segments.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    v$transaction

  3. #3
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    Try this code...

    select r.name "RBS",s.username "ORACLE_USER", p.username "UNIX_USER",p.spid "UNIX_PROCESS",
    s.sid "SID",s.serial# "SERIAL#",t.status,
    from v$process p, v$rollname r, v$session s,v$transaction t
    where s.taddr=t.addr
    and s.paddr=p.addr(+)
    and r.usn=t.xidusn(+)
    order by r.name;

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