Database Tuning (MOSC)

MOSC Banner

ORACLE 11.1.0.7.0 to 12.2 Upgread

edited Aug 1, 2018 10:45AM in Database Tuning (MOSC) 16 commentsAnswered

Dear Oracle Experts:-

I am in the process of upgrading my oracle database which is approx 90TB and wanted to be 100% sure with the SQL plans hence asking excerpts :

I will be Upgrading from 11.1.0.7.0 to 12.2C [ 11.2.4  which will be the stop point ] and trying to enable the SPM / load the plans of 11g to 12c in the below manners,correct me if something is going wrong as i have gone throw almost most of the oracle documentation and white papers.

Step 1: - Creating a STS for loading the SQL’s

exec sys.dbms_sqltune.create_sqlset(sqlset_name => 'DWH_01', sqlset_owner => 'Anjani', description => 'DWH_FOUNDATION on 08');     === ==> Can sys be the owner as if i am testing with my user or sys, it doesn't make any more differences

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center