Outlines

See Using Sql Area to calculate hash value
Please see Database Performance Tuning Guide

Please see Note:144194.1, Note:67536.1, Doc:204224.995, Doc:592900.999

 

How to create the outline
#not tested
#grant create any outline to the creating user

CURSOR_SHARING=SIMILAR or FORCE before creation and using the outline to permit replacement of literals with bind variables

Absolutely take the sql text from session trace

Enterprise Manager -> Tuning Pack -> Outline Management

Consider true for this parameters

QUERY_REWRITE_ENABLED

STAR_TRANSFORMATION_ENABLED

OPTIMIZER_FEATURES_ENABLE

 
Enable/disable the use of outlines
#You may use a trigger on database startup to automatically enable this
ALTER SESSION/SYSTEM SET USE_STORED_OUTLINES = TRUE | FALSE | <category>
ALTER system flush shared_pool
--Use a db startup trigger to enable outlines at startup

 How to specify hidden hints on SQL statements and Exchange the OUTLINE plan between the two OUTLINES: doc:92202.1
Delete outlines by category
begin
DBMS_OUTLN.DROP_BY_CAT('DEFAULT');
end;