Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

usage of Oracle SQL plan management in SAP

does SAP support usage of Oracle SQL Plan management in SAP? Are there any restrictions in automatically capturing SQL plan baseline and setting parameter optimizer_capture_sql_plan_baseline to TRUE?

I am using manual SQL plan baseline defining to fix execution plan for a given SQL (defined by SQL_ID) described in OSS NOTE 1776485, but here I am interested in using SQL plan baseline for preventing performance regression over Oracle changes that will impact CBO (mainly Oracle upgrades).

Former Member
Not what you were looking for? View more on this topic or Ask a question