rem ----------------------------------------------------------------------- rem Filename: acttrx.sql rem Purpose: Shows active (in progress) transactions rem Date: 12-Apr-1998 rem Author: Frank Naude, Oracle FAQ rem ----------------------------------------------------------------------- col name format a8 col username format a8 col osuser format a8 col start_time format a17 col status format a12 tti 'Active transactions' select username, terminal, osuser, t.start_time, r.name, t.used_ublk "ROLLB BLKS", decode(t.space, 'YES', 'SPACE TX', decode(t.recursive, 'YES', 'RECURSIVE TX', decode(t.noundo, 'YES', 'NO UNDO TX', t.status) )) status from sys.v_$transaction t, sys.v_$rollname r, sys.v_$session s where t.xidusn = r.usn and t.ses_addr = s.saddr /