Do you gather statistics in the way the CBO expects them?

You can't blame the optimizer unless you are sure you feed it with relevant statistics. There is the Auto Job which suits lots of cases, and there are some exceptions: volatile tables, partitioned tables, bulk load, histograms and bind variables, etc. You cannot gather all possible statistics everyday, and you cannot rely on stale ones. Let's define a few rules to know if you gather statistics in the right way, and how latest features can help in 12.1 and next releases.

Dienstag, 10.05.2016
14:00 - 14:45
Datenbank Betrieb

Franck Pachot

Oracle ACE-DirectorOracle OAK-Table
Currently at CERN, back to consulting at dbi-services in February 2020 Oracle Certified Master 12c, ACE Director, Oak Table member, Co-author of Oracle 12cR2 Multitenant (Oracle Press)

Weitere Vorträge von Franck Pachot

Understand multitenant beyond what is documented
Wednesday, 11.05.2016
11:00 - 11:45

Weitere Vorträge, die Sie interessieren könnten