Re: wrong start_time and start_date in v$transaction

Just playing probability games.

"Doesn't change" - depends on the power of 10 in the (hypothetical) error and the amount of time Nenad watched (maybe the time stamp increases by one second every 20 minutes, or every 200 minutes).

Regards
Jonathan Lewis

On Mon, Aug 31, 2020 at 11:11 PM Clay Jackson (cjackson) < Clay.Jackson_at_quest.com> wrote:

> 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:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
> Behalf Of *Jonathan Lewis
> *Sent:* Monday, August 31, 2020 2:54 PM
> *To:* ORACLE-L (oracle-l_at_freelists.org) <oracle-l_at_freelists.org>
> *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.
>
>
>
> 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-l