Gday everyone! I'm excited to announce that we have a special guest speaker again at the meetup and this time it's Graham Wood from Oracle - the man behind the modern Oracle performance tuning concept introduced in 10g and adopted by all performance diagnostic and tuning tools these days.

Graham is an architect in database development at Oracle HQ in Redwood Shores. Most of his 20 years of Oracle experience have been spent in performance-related areas including designing and tuning large high performance systems, benchmarking and building monitoring tools (such as our beloved Statspack). In the recent years, Graham has worked as part of the Oracle 10g Manageability team tasked with simplifying the process of tuning the operation of the database with the introduction of the Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM).

This is a unique opportunity to see Graham in Sydney during his short visit to Australia. Don't miss out!

DB Time-based Oracle Performance Tuning: Theory and Practice

Oracle 10g formally introduced the fundamental concept of DB Time as part of the Server Manageability effort. This concept underlies or is significantly used by many of the manageability technologies of the Diagnostic and Tuning packs in both 10g and 11g, including ADDM, SQL Tuning Advisor, Access Advisor, and Enterprise Manager. Less prominently but no less importantly the concept of DB Time is intended to be the new lingua franca for Oracle performance tuning.

This session will introduce the abstract theory of DB Time and its time-normalized sibling Average Active Sessions. The process of performance tuning using DB Time will be discussed and compared with other current methodologies including those based on wait-events and SQL trace. The session will discuss the Active Session History (ASH) technology and its critical relationship to quantifying the expenditure of DB Time in an active system across many dimensions of interest to performance analysts.

For those of you who are new to the meetup -- we are meeting at 5:30pm starting with pizza and beer as usual and around 6pm the presentation should start. The rest is flexible as the session tends to turn into an open discussion and we should target finish by 8:30pm but it's Friday night so you know how it goes. ;-)