The Oracle Optimizer Statistics Advisor in Oracle Database 220.127.116.11 is something I planned to write about for quite a while. Roy and I include this topic in the New Features section in our Upgrade / Migrate / Consolidate to Oracle Database 12.2 slide deck for some time. This blog post (in German only) by my former team mate Ulrike Schwinn inspired me to post something by myself.
Oracle Optimizer Statistics Advisor in Oracle Database 18.104.22.168
First of all you’ll find the feature documented in the Oracle Database 12.2 Database SQL Tuning Guide.
The advisor task (‘
Statistics Advisor‘) …