kelvinewilliams/uncommitted_transactions.sql

## uncommitted_transactions.sql
create view uncommitted_transactions as
select t.start_time,s.sid,s.serial#,s.username,s.status,s.schemaname,
s.osuser,s.process,s.machine,s.terminal,s.program,s.module,to_char(s.logon_time,'DD/MON/YY HH24:MI:SS') logon_time
from v$transaction t, v$session s
where s.saddr = t.ses_addr
order by start_time;
	create view uncommitted_transactions as
	select t.start_time,s.sid,s.serial#,s.username,s.status,s.schemaname,
	s.osuser,s.process,s.machine,s.terminal,s.program,s.module,to_char(s.logon_time,'DD/MON/YY HH24:MI:SS') logon_time
	from v$transaction t, v$session s
	where s.saddr = t.ses_addr
	order by start_time;