On Tue, Sep 8, 2020 at 1:52 PM Ravi Krishna wrote:
>
>
> Interesting. Are you telling the Oracle version of the code had no
> intermittent COMMIT and relied on one
> final COMMIT at the end. Even in Oracle developers must have planned for
> commit since a long running
> open transaction can lead to “snapshot too old” error.
>
Yes, I am saying just that. With one important clarification: there were no
transactions as SELECT does not open them and the application does not
change anything on that connection.
So, no 'snapshot too old' and no COMMITs.
--
Regards,
Michael Holzman