My Oracle Support Banner

How to Enable USE_STORED_OUTLINES Permanently (Doc ID 560331.1)

Last updated on FEBRUARY 20, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 8.1.7.0 to 11.1.0.6 [Release 8.1.7 to 11.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Goal
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.