Enable/Disable Stored Outline Auto-creation/Auto-use

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

There are two object actions that can be performed against one or more stored outlines, that dictate whether execution plans are automatically generated or used:

Enable/disable stored outline auto-creation

Lets you specify whether Oracle to create a stored outline for every query submitted to the server.

Enable/disable stored outline auto-use

Lets you specify whether Oracle uses stored outlines to generate execution plans.

Platform Availability

To Specify Whether Stored Outlines are Automatically Created and Used

  1. Initiate an Enable/disable stored outline auto-use or Enable/disable stored outline auto-creation action against one or more stored outlines. For more information see Initiating an object operation.
  2. Use the following table as a guide to understanding and modifying settings in the wizard:
Step Settings and tasks

Action Options

Automatically create stored outlines or Automatically use stored outlines

Lets you enable or disable the feature associated with your selection.


Lets you select an outline category. This option is only available if you enabled the feature.

No Override

If selected, outlines will not override. This option is only available if you enabled the feature.


Review the referring and referred objects that will be automatically resolved when you execute this operation.


Preview the DDL generated for the operation. For more information, see Preview.

3. When ready, click Execute.