Hotsos Symposium Speaker – Dave Abercrombie

Mr. Abercrombie is a new Hotsos Symposium presenter.


Dave AbercrombieMr. Abercrombie is the Principal Database Architect at Convio, a company that he helped found about ten years ago. Convio is an ASP providing fundraising, advocacy, event fundraising, web content management and email market services for large non-profits. Dave focuses on Oracle diagnostics, tuning and design from the perspective of the application. Dave bridges the gap between the DBAs and the application developers, speaking both languages.

Mr. Abercrombie has presented at the Northern California Oracle Users Group (NoCOUG) August 2008 Conference. Dave also has extensive experience speaking and training in-house staff on Oracle performance. He also enjoys speaking in public about other topics, including disaster first aid, meditation, and yoga.

Presentation Title

A Tour of the AWR Tables


Introduced in version 10g, Oracle's Automatic Workload Repository (AWR) provides diagnostic information for performance and scalability studies, automatically recording a rich variety of database performance statistics.

What's the best way to leverage this wealth of data? While you can run Oracle-supplied AWR reports, or use Oracle features such as the Automatic Database Diagnostic Monitor (ADDM), each Oracle database presents its own unique tuning challenges. In this presentation, you'll learn how to work directly with AWR tables, using customized queries to improve insight into your own particular scalability issues.

Topics include:

  • Important AWR tables, their contents, how to join them, and their quirks and limitations.

  • Sample queries that can be easily adapted to focus on your own unique set of problems.

  • Estimating the "Average Active Session" metric.

  • Simple statistical techniques to find spikes and other types of anomalous behavior.

  • A comparison of techniques used for historical scalability studies with those used for real-time performance crisis resolution.

  • Use of DBMS_APPLICATION_INFO and JDBC end-to-end metrics.

  • Useful tips on configuring AWR.

This presentation also applies some industrial and quality engineering approaches recently described by Robyn Sands to the use of AWR tables, and these ideas are also combined with use of the DB time metric championed by Kyle Hailey.

Presentation Materials

Presentation materials are available online to attendees only. Dave's presentation slides and white paper can be found on the Hotsos portal. Please remember to use your portal id and password to log into the site.


The speaker schedules can be found at the following links: