Hi everyone,
in short we are planning to upgrade our 11g instances to 12c. We are exporting and then importing in a new environment so not an in-place upgrade.
Some of the team are suggesting that we just have to accept that performance will tank when we switch to the new environment as the DB will need time to 'warm up'. By this they are are referring to execution plans etc.
If schema statistics are being copied over as part of the export is this predicted performance apocalypse still to be reasonably expected?
Is there anything else we can do to make the transition more smooth?
I really can't see our users accepting the line 'the db needs time to warm up!'.
Any insight, articles or personal experience appreciated.