Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Avoiding DB Performance degradation during upgrade

3372911Jul 24 2018 — edited Jul 24 2018

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.

Comments

807573
found it
attributeTypes: ( 1.3.6.1.1.1.1.30 NAME 'nisDomain'
       DESC 'NIS domain'
       SYNTAX 1.3.6.1.4.1.1466.115.121.1.26 )
objectClasses: ( 1.3.6.1.1.1.2.15 NAME 'nisDomainObject' SUP top AUXILIARY
       DESC 'Associates a NIS domain with a naming context'
       MUST nisDomain )
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 21 2018
Added on Jul 24 2018
#database-upgrade, #performance
3 comments
198 views