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

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

• ORCL

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.
	Category	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.
Dependencies	Review the referring and referred objects that will be automatically resolved when you execute this operation.
Preview	Preview the DDL generated for the operation. For more information, see Preview.

3. When ready, click Execute.