Loading a SQL PLAN BASELINE Automatically - But with a FILTER
Hi
We would like to know if we are capturing the baselines automatically is there a way not to capture the SQL for recursive statements or where the parsing schema name is SYS / Non application specific shcemas?
Our database is 19.8
We plan to set the optimizer_capture_sql_plan_baselines = true and let the system run for a day (so that daily work load is captured) and then disable it and then again on month end, set it to TRUE again for 12 hours when the batch job runs and then set it back to false after that.
This way we would have captured baselines representing a typical workload