The Outlines tab provides detailed information about outlines created by the query during the statement execution process on the Overview tab.

It provides information including the SQL statement name, whether the outline is enabled, and the Name, Category, and Hints associated with the outline. Additionally, the Drop parameter specifies whether it is dropped at execution time.

In order to view outlines, the session needs to have USE_STORED_OUTLINES=true set prior to execution. Outlines in tuning are created for the DEFAULT category, by default. Use the following commands to enable outlines with the default settings:

alter system set USE_STORED_OUTILNES=true; alter system set USE_STORED_OUTLINES=‘DEFAULT’; alter session set USE_STORED_OUTLINES=true;

Additionally, in order for a session to USE_STORED_OUTLINES, the user requires the create any outline role. Use the following command to set up the proper permissions:

grant create any outline to [user];


IDERA |  Products | Purchase | Support |  Community |  Resources |  About Us  | Legal