How to Enable USE_STORED_OUTLINES Permanently (Doc ID 560331.1)

Last updated on NOVEMBER 17, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.0 to 11.1.0.6 [Release 8.1.7 to 11.1]
Information in this document applies to any platform.

Goal

A Stored Outline will only be used when the parameter USE_STORED_OUTLINES is set persistently.  If parameter is set  using alter session or by defining in  pfile/spfile  the change is not permanent and will no longer be set after database has been restarted.

A STARTUP trigger needs to be defined in order to make this setting persistent after restart of database

NOTE: Stored outlines will be desupported in a future release in favor of SQL plan management. In Oracle Database 11g stored outlines continue to function as in past releases. However, Oracle strongly recommends that you use SQL plan management for new applications. SQL plan management creates SQL plan baselines, which offer superior SQL performance and stability compared with stored outlines.

For more information see:

<Document  1359841.1> Master Note: Plan Stability Features (Including SQL Plan Management (SPM))

 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms