Show current transactions per user session

--
-- SQL script to show transactions for each user session
--
SELECT	s.logon_time, t.start_time, oc.sql_text, s.username "User Name",
	s.osuser "OS User", s.status "Status", lockwait "Lock Wait", 
	s.program "Program", s.logon_time "Connect Time", p.program "P Program", 
	si.physical_reads "Physical Reads", si.block_gets "Block Gets", 
	si.consistent_gets "Consistent Gets", si.block_changes "Block Changes", 
	si.consistent_changes "Consistent Changes", s.process "Process", 
	p.spid, p.pid, s.serial#, si.sid 
FROM	sys.v_$sess_io si, sys.v_$session s, sys.v_$process p ,
	v$open_cursor oc, v$transaction t
WHERE s.username is not null 
AND si.sid(+)=s.sid 
AND s.sid = oc.sid
AND p.addr(+)=s.paddr 
AND s.saddr(+)= t.ses_addr
ORDER BY s.status, si.consistent_gets+si.block_gets desc
/