CREATE_STORED_OUTLINES

Property	Description
Parameter type	String
Syntax	`CREATE_STORED_OUTLINES = { true \| false \|` `category_name` `}`
Default value	There is no default value.
Modifiable	`ALTER SESSION`, `ALTER SYSTEM`
Basic	No

CREATE_STORED_OUTLINES determines whether Oracle automatically creates and stores an outline for each query submitted during the session.

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 the DEFAULT 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 the category_name category.

See Also:
Oracle Database Performance Tuning Guide for more information on setting this parameter