SQL quesry and RBS segment
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
order by r.name;
Click Here to Expand Forum to Full Width