How to Enable USE_STORED_OUTLINES Permanently
(Doc ID 560331.1)
Last updated on JUNE 15, 2021
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
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database 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> Primary Note: Plan Stability Features (Including SQL Plan Management (SPM))
For more information see:
<Document 1359841.1> Primary 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 |