Re: Issues during Upgrade
Date: Fri, 27 Aug 2021 14:20:28 +0000
Message-ID: <BN6PR01MB254735E96B6C3E2385BF3103CEC89_at_BN6PR01MB2547.prod.exchangelabs.com>
You can avoid the bug altogether by patching to 19.11 or .12 instead of .9 though doing so may be a little hard if you have already tested 19.9 in test and are planning to upgrade production now.
Version 19.12 offers a password transition period backport where both the old and new password for a username is in effect to support rolling out the change in the application.
Mark Powell
Database Administration
(313) 592-5148
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Pap <oracle.developer35_at_gmail.com> Sent: Thursday, August 26, 2021 4:18 PM
To: Oracle L <oracle-l_at_freelists.org> Subject: Issues during Upgrade
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 Fri Aug 27 2021 - 16:20:28 CEST