Difference between revisions of "Transactions and undo related things"
Jump to navigation
Jump to search
(Created page with "Show active transactions <source lang="sql"> select t.start_time, s.inst_id, s.sid, s.serial#, s.username, s.osuser, s.machine, s.program, s.logon_time, s.last_call_et, s.wait...") |
|||
Line 6: | Line 6: | ||
where s.inst_id = t.inst_id | where s.inst_id = t.inst_id | ||
and s.saddr = t.ses_addr; | and s.saddr = t.ses_addr; | ||
+ | </source> | ||
+ | |||
+ | Show minimum active scn (used eg by storage indexes) | ||
+ | <source lang="sql"> | ||
+ | select min_act_scn from x$ktumascn; | ||
</source> | </source> |
Latest revision as of 12:03, 20 June 2016
Show active transactions
select t.start_time, s.inst_id, s.sid, s.serial#, s.username, s.osuser, s.machine, s.program, s.logon_time, s.last_call_et, s.wait_class, s.seconds_in_wait
from gv$transaction t
, gv$session s
where s.inst_id = t.inst_id
and s.saddr = t.ses_addr;
Show minimum active scn (used eg by storage indexes)
select min_act_scn from x$ktumascn;