Different Execution Plan on 11g Compared to 10g for SQL Plan Baseline Created from a SQL Tuning Set Results
(Doc ID 1540948.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document