Issues during Upgrade
From: Pap <oracle.developer35_at_gmail.com>
Date: Fri, 27 Aug 2021 01:48:27 +0530
Message-ID: <CAEjw_fje0iH13oJbb1dQMWR=_w8GQo6GnQN8afU3kxfP5YeoDQ_at_mail.gmail.com>
We are planning to upgrade to 19C (exact patch version 19.9.0.0.0) from 12.1 version. We are using a lot of global temporary tables in our application. And one of the team members just highlighted the bug below but considering our lower environment not having much data as we have in production we were unable to see/test the exact volume from application code. So just wanted to check with listers here, if anybody experienced this bug?
And as we don't have exact volume in the lower environment, So we are planning to mimic global temporary table batch insert manually through a plsql block in the lower environment/database. Will that be a good enough test to ensure we are really going to hit this in production or not?
Date: Fri, 27 Aug 2021 01:48:27 +0530
Message-ID: <CAEjw_fje0iH13oJbb1dQMWR=_w8GQo6GnQN8afU3kxfP5YeoDQ_at_mail.gmail.com>
We are planning to upgrade to 19C (exact patch version 19.9.0.0.0) from 12.1 version. We are using a lot of global temporary tables in our application. And one of the team members just highlighted the bug below but considering our lower environment not having much data as we have in production we were unable to see/test the exact volume from application code. So just wanted to check with listers here, if anybody experienced this bug?
And as we don't have exact volume in the lower environment, So we are planning to mimic global temporary table batch insert manually through a plsql block in the lower environment/database. Will that be a good enough test to ensure we are really going to hit this in production or not?
Bug 31031240 Insert into GTT (Global Temporary Tables) Runs Slow with increasing no.of records
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 26 2021 - 22:18:27 CEST