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
Michael Holzman
