Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 02nd, 2009
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
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.