SQL Performance (MOSC)

MOSC Banner

Execution plan after upgrade/migrate from 12.1C TO 12.2C

edited May 6, 2018 9:14AM in SQL Performance (MOSC) 5 commentsAnswered

Hello professionals,

we are planing to upgrade our database from 12.1.0.2 to 12.2.0.1. The concern we have is about the execution plan. Now we didn't use multiple tenant, and we want to do:

1. on same server, install 12.2.0.1 and upgrade database to new version.

2.  Generate the XML description file

3. on new machine install 12.2.0.1, create database as multiple tenants DB

4. copy XML description file to new machine

5. plug in DB as new PDB using XML file (databases are saved on SAN, so we just keep the same path for all files, and won't files over)

question is after we migrate to new PDB, it will keep the original DB existing execution plans or not?  we are worry about the performance issue which maybe be caused by the execution plan. Or should we generate the SQL baseline, export it and import into database after we migrate it to PDB?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center