Does anyone have this parameter set to TRUE in their production environment? Has anyone used this approach in SAP environment? By default it is turned off in Oracle 11g but seems very logical and useful. Just wanted some opinions before I go test it.
>> is the parameter optimizer_capture_sql_plan_baselines set to true?
Yes, I actived this parameter previously, for the testing reasons, but couldn't see any dramatic performance gain. As far as I understand that it is giving you ability to manual controlling to choose execution plan by CBO.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.