Different Execution Plan on 11g Compared to 10g for SQL Plan Baseline Created from a SQL Tuning Set Results
Last updated on AUGUST 25, 2017
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
- The SQL Tuning Set (STS) was generated in a 10.2. database
- STS copied over to a 11.2.0 database using the DBMS_SQLTUNE.PACK_STGTAB_SQLSET and DBMS_SQLTUNE.UNPACK_STGTAB_SQLSET.
- SQL Plan Baseline (SPB) was generated from the SQL Tuning Set (STS), but the SQL Plan Baseline ends up with a different xplan than what was in the SQL Tuning Set.
The SQL Tuning Set was copied from 10g to 11g
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms