RE: wrong start_time and start_date in v$transaction

From: Clay Jackson (cjackson) <"Clay>
Date: Mon, 31 Aug 2020 22:10:57 +0000
Message-ID: <>

But, didn’t Nenad say “start_time doesn’t change over time on the affected databases”.

Could it be as simple as the start time of the instance?

But then why SOME transactions and not ALL? Perhaps something as simple as “the first transaction in each session”?

Clay Jackson

From: <> On Behalf Of Jonathan Lewis Sent: Monday, August 31, 2020 2:54 PM
To: ORACLE-L ( <> Subject: Re: wrong start_time and start_date in v$transaction

CAUTION: This email originated from outside of the organization. Do not follow guidance, click links, or open attachments unless you recognize the sender and know the content is safe.


How about one "what if" (based on a bug pattern seen in an older version of Oracle) before doing anything complicated. What if: the thing creating the timestamp for the transaction is dividing a counter by the wrong power of 10 before adding seconds to the database startup time. If you check v$instance.startup_time + v$timer.hsecs/(100 * 86400) at the start of the transaction that should (I think) be very close to sysdate: can you get your transaction start time by dividing hsecs by a couple more powers of 10 ?

Jonathan Lewis

Received on Tue Sep 01 2020 - 00:10:57 CEST

Original text of this message