SQL Plans from Oracle 10.2 SQL Tuning Set (STS) are Not Uploaded into SQL Plan Management (SPM) in Oracle 11.2
Last updated on SEPTEMBER 15, 2016
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
- When trying to upload SQL Plans from Oracle 10.2 in a STS (SQL Tuning Set) captured on 10.2 using DBMS_SPM.load_plans_from_sqlset, the SQL Plan Manager (SPM) in Oracle 11.2 reports than no plans are loaded. For example:
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