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...") |
(No difference)
|
Revision as of 10:59, 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;