https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_6005.htm#SQLRF01305 Stored outlines will be desupported in a future release in favor of SQL plan management. In Oracle Database 11g Release 1 (11.1), 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.
If you have existing stored outlines, please consider migrating them to SQL plan baselines by using the LOAD_PLANS_FROM_CURSOR_CACHE or LOAD_PLANS_FROM_SQLSET procedure of the DBMS_SPM package. When the migration is complete, you should disable or remove the stored outlines.

kinky catdcdba,
Есть недокументированный sqlpatch, он вроде никак не лицензится, пока не документирован. Но хз можно ли пускать его в продакшн, но свой страх и риск

ну не такой уж он и недокументированный - дока
В блоге команды оптимизатора пишут :
авторDo we need additional licenses or the SQL diag pack to use this?
- No. No additional licenses are needed to use SQL Repair Advisor or SQL patches. SQL Repair Advisor is available as part of Oracle Database Enterprise Edition 11g.