| Graham Wood
Oracle |
About Graham Wood 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 monitoing tools (such as Statspack). More recently Graham has worked as part of the Oracle 10g Managability 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). |
| Website/Blog |
Video Graham Wood at MOOW2008 |
| Track: ORA | |
Session title |
Session description |
The ASHes of Time? |
Active Session History (ASH) was introduced in Oracle Database 10g as part of the instrumentation to support the Automatic Database Diagnostic Monitor (ADDM) and has been enhanced in each subsequent release. The sampled data in ASH allows us to do highly detailed performance analysis in many different dimensions (session, SQL, application etc.). Examples will be presented of using ASH to identify the source of performance problems with emphasis on using the newer capabilities. |
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. |