Hotsos Symposium Speaker – Doug Burns

Doug Burns is a returning Hotsos Symposium presenter.

Biography

Doug BurnsDoug Burns is an independent contractor who has 20 years of experience working with Oracle in a range of industries and applications. As well as presenting at a number of conferences, he has developed, taught, and edited performance-related courses for both Oracle UK and Learning Tree International. He is a member of The Oak Table Network.

Doug is an Oracle Ace Director.

Presentation Titles

Statistics on Partitioned Objects 2012
 
and
 
Falling in Love All Over Again ... OEM 12c Performance Page Enhancements

Abstracts

Statistics on Partitioned Objects 2012: Optimal SQL execution plans are rooted in the quality of the statistics describing the underlying objects that are used by the Cost Based Optimizer.

Statistics maintenance is a particular challenge on Data Warehouse systems holding large data volumes that support complex and flexible user reporting requirements. Such systems are likely to use partitioned tables and indexes to complicate the picture further.

Continuing the theme of last years presentation, the 2012 version will look at additional lessons learned during the past year and focuses on 11g features.

Review of Core Issues

  • The quality/performance trade off
    • Global and Approximate Global statistics METHOD_OPT and Column Statistics
  • Alternative Strategies
    • Copying statistics
    • Setting statistics
  • 11g improvements
    • AUTO_SAMPLE_SIZE
    • Incremental Statistics

The presentation will discuss a variety of problems and bugs with the various approaches that should be avoided as well as offering guidelines to help you design the best statistics collection strategy for your requirements.

Falling in Love All Over Again ... OEM 12c Performance Page Enhancements: Oracle 10g introduced significant instrumentation enhancements and the OEM 10g Performance Pages illustrated them to make performance analysis much easier. OEM 12c is the latest evolutionary stage of the Performance Pages and this presentation shows the new features that make them even more compelling and useful in more situations.

Presentation Materials

Presentation materials are available online to attendees only.

Schedule

The speaker schedule is as follows:

Free Hit Counter