Database Tuning (MOSC)

MOSC Banner

Best practice for database uprades pertaining to SQL Plan Control.

edited Nov 26, 2019 11:11AM in Database Tuning (MOSC) 3 commentsAnswered

I have general question regarding existing SQLProfiles and SQL Baselines as they pertain to database migrations to new releases.
We are migrating some application schemas from Oracle release 11.2.0.4 to a 12.2.0.1 database with a new character set.  The existing 11.2.0.4 database has 100 enabled SQL profiles.  These profiles were created as early at 2008 with the most current being 2015.  My question is about a best practice for the migration.

I see two strategies.

1. Migrate all of the 100 SQL profiles created at various earlier releases of Oracle to the new release and start regression testing.

2. Migrate no stale SQL profiles, and instead, test for regression in the new release in a test database.  If there is any SQL regression, run the Tuner or Access Advisor to tune the SQL in 12.2.  If all fails to improve the performance, and an old SQL Profile exists in a back release, migrate the one old SQL Profile to the database and test again.

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