How to Load SQL Plans into SQL Plan Management (SPM) from the Automatic Workload Repository (AWR)

(Doc ID 789888.1)

Last updated on SEPTEMBER 28, 2017

Applies to:

Oracle Database - Enterprise Edition - Version to [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