1.62 CREATE_STORED_OUTLINES
CREATE_STORED_OUTLINES
determines whether Oracle automatically creates and stores an outline for each query submitted during the session.
Property | Description |
---|---|
Parameter type |
String |
Syntax |
|
Default value |
There is no default value. |
Modifiable |
|
Modifiable in a PDB |
Yes |
Basic |
No |
Values
-
true
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 theDEFAULT
category, then that outline will remain and a new outline will not be created. -
false
Disables automatic outline creation during the session. This is the default.
-
category_name
Enables the same behavior as
true
except that any outline created during the session is stored in thecategory_name
category. -
NOOVERRIDE
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 specifyNOOVERRIDE
, then this setting takes effect in all sessions.
See Also:
Oracle Database SQL Tuning Guide for more information on setting this parameter