Shulou(Shulou.com)06/01 Report--

Mass execution of DML statements results in a large number of rollback segments, and rollback operations, how to intuitively query data rollback?

Query rollback execution progress in stand-alone environment

Select / * + rule * / s.sid, r.name rr, nvl (s.username t.used_ublk blk from v$lock no transaction') us, s.osuser os, s.terminal te, t.used_urec rec, t.used_ublk blk from v$lock l, v$session s, v$rollname r journal transaction t where l.sid = s.sid (+) and trunc (l.id1/65536) = r.usn and l.type = 'TX' and t.ses_addr = s.saddr and l.lmode = 6

Query rollback execution progress in stand-alone environment

Select / * + rule * / s.sid, r.name rr, nvl (s.username t.used_ublk blk from v$lock no transaction') us, s.osuser os, s.terminal te, t.used_urec rec, t.used_ublk blk from v$lock l, v$session s, v$rollname r journal transaction t where l.sid = s.sid (+) and trunc (l.id1/65536) = r.usn and l.type = 'TX' and t.ses_addr = s.saddr and l.lmode = 6

Cluster environment query rollback execution progress

Select / * + rule * / s.sid, r.name rr, nvl (s.username t.used_ublk blk from gv$lock no transaction') us, s.osuser os, s.terminal te, t.used_urec rec, t.used_ublk blk from gv$lock l, gv$session s, v$rollname r journal transaction t where l.sid = s.sid (+) and trunc (l.id1/65536) = r.usn and l.type = 'TX' and t.ses_addr = s.saddr and l.lmode = 6

Query rollback execution progress in stand-alone environment

Select / * + rule * / s.sid, r.name rr, nvl (s.username t.used_ublk blk from v$lock no transaction') us, s.osuser os, s.terminal te, t.used_urec rec, t.used_ublk blk from v$lock l, v$session s, v$rollname r journal transaction t where l.sid = s.sid (+) and trunc (l.id1/65536) = r.usn and l.type = 'TX' and t.ses_addr = s.saddr and l.lmode = 6

Summary

The above is the detailed explanation of the Oracle rollback section introduced by the editor. I hope it will be helpful to you. If you have any questions, please leave a message for me, and the editor will reply you in time. Thank you very much for your support to the website!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.