Presentation Title: Statistics Gathering Best Practice & Statistics Advisor
Speaker: Mr Franck Pachot Oracle ACE Director Oracle Certified Master
Company: dbi-services
Presentation abstract: You can't blame the optimizer unless you are sure to 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.

12.2 brings a new advisor to check and implement the best practices. However, before implementing the recommandations, better to understand the reasons behind those best practices.

Presentation begins: 07/12/2016 12:30
Presentation duration: 50
Presentation content level: 4 (1 = indepth, 5 = strategic overview)
Audience experience: Beginner/Exploratory
Audience function: Product User
Speaker biography:  Senior Consultant & Oracle Technology Leader at dbi services Oracle Certified Master Database 12c, ACE Director Working in all area of Oracle Database as consultant and trainer Co-author of Oracle Database 12c Release 2 Multitenant
Related topics: Database: Management & Administration, Database: Performance & Internals
Hall: Hall 11A

P-ORA-20160511-001-DoYouGatherStatistics.pdf1.2 MB07/12/2016 15:43:26
TECH16-STATS.mp417.8 MB07/12/2016 20:50:19