Re: wrong start_time and start_date in v$transaction
From: Jonathan Lewis <jlewisoracle_at_gmail.com>
Date: Mon, 31 Aug 2020 22:54:10 +0100
Message-ID: <CAGtsp8mwTYdkB0fi7p-vRLqBpwsw_bnXF--MUoUyLUH3DBQrPg_at_mail.gmail.com>
Date: Mon, 31 Aug 2020 22:54:10 +0100
Message-ID: <CAGtsp8mwTYdkB0fi7p-vRLqBpwsw_bnXF--MUoUyLUH3DBQrPg_at_mail.gmail.com>
Nenad,
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 ?
Regards
Jonathan Lewis
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 31 2020 - 23:54:10 CEST