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.