Re: Issues during Upgrade

Bugs have unexpected behaviour. I doubt you will get into something conclusive by just testing it/batch inserts into GTT on your lower environment which is having less data volume.

On Fri, Aug 27, 2021 at 1:49 AM Pap <oracle.developer35_at_gmail.com> wrote:

> 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-l