|Oracle® Database Reference
11g Release 2 (11.2)
Part Number E17110-04
|Default value||There is no default value.|
CREATE_STORED_OUTLINES determines whether Oracle automatically creates and stores an outline for each query submitted during the session.
Enables automatic outline creation for subsequent queries in the same session. These outlines receive a unique system-generated name and are stored in the
DEFAULT category. If a particular query already has an outline defined for it in the
DEFAULT category, then that outline will remain and a new outline will not be created.
Disables automatic outline creation during the session. This is the default.
Enables the same behavior as
true except that any outline created during the session is stored in the
NOOVERRIDE specifies that this system setting will not override the setting for any session in which this parameter was explicitly set. If you do not specify
NOOVERRIDE, then this setting takes effect in all sessions.
See Also:Oracle Database Performance Tuning Guide for more information on setting this parameter