Re: any way to know how old a transaction is

v$transaction.start_time

e.g.

select a.start_time, b.sid, b.username
from v$transaction a, v$session b
where a.ses_addr = b.saddr;

HTH,
Dave

rpr wrote:
> Hi,
> Is there a way for me to know how old an uncommitted transaction is.
> Meaning since how long it is there and uncommitted. Thank you
Received on Mon Nov 10 2003 - 20:47:00 CST