Hi,
I need to know if exist an Oracle query that allows me to show open transactions (uncommitted)
I use this query:
select t.start_time,s.sid,s.serial#,s.username,s.status, s.sql_id
from v$transaction t, v$session s
where s.saddr = t.ses_addr
BUT I'd like to know if there are uncommitted transactions 3 days ago.
Thanks in advance!