How to Load SQL Plans into SQL Plan Management (SPM) from the Automatic Workload Repository (AWR)
Last updated on SEPTEMBER 28, 2017
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.4 to 184.108.40.206 [Release 10.2 to 12.1]
Information in this document applies to any platform.
The goal of the document is to provide steps for loading a sql plan into sql plan baseline from AWR. Please remember that license is required to use Oracle Diagnostics Pack:
NOTE: Oracle Diagnostics Pack (and Oracle Tuning Pack) is available with Enterprise Edition ONLY.
For further details of pack licensing see:
Oracle® Database Licensing Information
12c Release 1 (12.1)
Part number E17614-08
Chapter 1 1 Oracle Database Editions
Feature Availability by Edition
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms