-
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.
-
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|