Sadly, I've seen refusal to use a capability of Oracle too many times with SQL Profiles and SQL Plan Baselines where DBAs/organizations hinder the adoption of these capabilities. Reference blog post: rogercornejo.com/oracle-blog/20…
Sadly, I've seen refusal to use a capability of Oracle too many times with SQL Profiles and SQL Plan Baselines where DBAs/organizations hinder the adoption of these capabilities. Reference blog post: rogercornejo.com/oracle-blog/20…
@OracleDBTuning Lazy DBAs. They don't want to manage sql plan baselines and prefer to blame developers for slow queries (and of course don't give any access to prod performance info to help them) 🤷🏻♂️
@OracleDBTuning true , its super frustrating sometimes people don't want to use those features,I ll take stability over new plans with expected better performance. also sometimes annoying is that these features dont work for dynamic statements , even with profiles set with force_match to true.
@OracleDBTuning You can use sql baselines in SE2 as outlines were desupported you are limited to one baseline per sql but this can be enough to be useful to pin a cached plan.
@OracleDBTuning SQL profiles are priced optionally. Baselines are a band aid. Developers issue a new version and back to day zero go you. So, dba know what they do.
@OracleDBTuning This is a great way to influence the optimizer and in most cases prevent it from going off the rails.