Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Uncommitted Transactions

R. RoyalOct 2 2015 — edited Oct 9 2015

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!

This post has been answered by unknown-7404 on Oct 2 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 6 2015
Added on Oct 2 2015
15 comments
3,200 views