Hotsos is very pleased to announce that Doug Burns is returning for Hotsos Symposium 2012! He has graciously accepted the spots formerly held by Randolf Geist, who had to cancel. While we will miss meeting Mr. Geist, we are very happy that Doug agreed to take his slots.
Doug 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 and an Oracle Ace Director.
Doug's Topics: Statistics on Partitioned Objects 2012 and Falling in Love All Over Again ... OEM 12c Performance Page Enhancements
Descriptions of Sessions: 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
- 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.
There are a few more seats available for Hotsos Symposium 2012, but you'll need to register soon! We don't want you to miss out on all these fabulous speakers. ;)