 |
|
Oracle Tips by Burleson |
Oracle 10g create_stored_outlines
Parameter type – String
Syntax – create_stored_outlines = { true |
false | category_name }
Default value – There is no default value.
Modifiable – ALTER SESSION, ALTER SYSTEM
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.
-
Catalog_name – Enables the same behavior
as true except that any outline created during the session is stored
in the catalog_name category.
The following statement sets the default
outline category for a session:
SQL> alter
session set create_stored_outlines = 'true';
Get the complete Oracle10g story:
To get the code instantly, click here:
Need an Oracle Mentor?
BEI is now offering personal mentors for Oracle DBAs where you can have an
Oracle expert right at your fingertips, anytime day or night. We work with
hundreds of Oracle databases every year, so we know exactly how to quickly
assist you with any Oracle question.
Why risk an unplanned outage? You can now get telephone access to Don
Burleson or any of his Oracle Certified DBAs with more than 20 years of
full-time IT experience. Click here for details:
http://www.dba-oracle.com/service_oracle_backup.htm
|
