Adaptive Dynamic Sampling
Track
DBA & Infrasturcture
Date and time
Wednesday, 14. October 2015., 12:30
Room
Hall 2 Castle
Duration
45'
Based on object statistics stored in the data dictionary, the query optimizer can’t always accurately estimate the cost of an operation or predicate. When the query optimizer recognizes such a case, in some situations it can gather additional statistics through dynamic sampling. The original implementation of dynamic sampling was introduced in Oracle Database 9.2 and, up to 11.2.0.3, only marginally improved. However, Oracle Database 11.2.0.4 and 12.1 introduces a new implementation that completely changes the way dynamic sampling works. The aim of this presentation is to explain and demonstrate how the new implementation works.
Lecture details
About speaker
Christian Antognini, author
Since 1995, Christian Antognini has focused on understanding how the Oracle database engine works. His main interests include logical and physical database design, the integration of databases with Java applications, the query optimizer and basically everything else related to application performance management. He is currently working as a senior principal consultant and trainer at Trivadis in Zürich, Switzerland.He is a proud member of the OakTable Network and an Oracle ACE Director. Christian is the author of Troubleshooting Oracle Performance (Apress, 2008/2014) and the co-author of Der Oracle DBA (Hanser, 2011).
HrOUG.hr
The conference is organized by the Croatian Association of Oracle users. More about the association can be found at Hroug.hr.
Follow us on Facebook
Follow us on Twitter
Keep yourself up to date with all updates! Follow @HrOUG_2015Best Sponsor
Better Sponsor
Good Sponsor
Media Sponsor
