Stored outlines are deprecated. They are still supported for backward compatibility. However, Oracle recommends that you use SQL plan management instead. SQL plan management creates SQL plan baselines, which offer superior SQL performance stability compared with stored outlines.
You can migrate existing stored outlines to SQL plan baselines by using the
MIGRATE_STORED_OUTLINEfunction of the
DBMS_SPMpackage or Enterprise Manager Cloud Control. When the migration is complete, the stored outlines are marked as migrated and can be removed. You can drop all migrated stored outlines on your system by using the
DROP_MIGRATED_STORED_OUTLINEfunction of the
See Also: Oracle Database SQL Tuning Guide for more information about SQL plan management and Oracle Database PL/SQL Packages and Types Reference for information about the
CREATE OUTLINE for information on creating an outline
To drop an outline, you must have the
OUTLINE system privilege.
Specify the name of the outline to be dropped.
After the outline is dropped, if the SQL statement for which the stored outline was created is compiled, then the optimizer generates a new execution plan without the influence of the outline.
Dropping an Outline: Example
The following statement drops the stored outline called
DROP OUTLINE salaries;