Re: Flashback query
From: Jonathan Lewis <jlewisoracle_at_gmail.com>
Date: Tue, 11 Oct 2022 21:03:14 +0100
Message-ID: <CAGtsp8m-DrGp1Bqf45FvLziwUjd2T3jRLYE+xKHYK4qpnzwxsQ_at_mail.gmail.com>
Date: Tue, 11 Oct 2022 21:03:14 +0100
Message-ID: <CAGtsp8m-DrGp1Bqf45FvLziwUjd2T3jRLYE+xKHYK4qpnzwxsQ_at_mail.gmail.com>
This went into my spam folder for no good reason; but I see Mark Powell
explained the significance of the "create procedure" just after the "set
transaction".
Regards
Jonathan Lewis
On Tue, 11 Oct 2022 at 19:19, Michael O'Shea/Woodward Informatics Ltd < woodwardinformatics_at_strychnine.co.uk> wrote:
> The *transaction mode* approach warrants further investigation (as it is
> something I can control from a developers perspective). A sanity check
> using *read only* gives the two cursors still polluted with commits from
> other transactions (in other sessions) however, as below, so I will need to
> investigate further.
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Oct 11 2022 - 22:03:14 CEST