Database Tuning (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center