ORACLE 11.1.0.7.0 to 12.2 Upgread
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