|
|
 |
|
|
Upcoming Events
|
|
|
| | Su | Mo | Tu | We | Th | Fr | Sa |
|---|
| 28 | 29 | 30 | 1 | 2 | 3 | 4 | | 5 | 6 | 7 | 8 | 9 | 10 | 11 | | 12 | 13 | 14 | 15 | 16 | 17 | 18 | | 19 | 20 | 21 | 22 | 23 | 24 | 25 | | 26 | 27 | 28 | 29 | 30 | 31 | 1 | | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
|
|
Sponsors |
 |
|
CTOUG EVENTS
DB Time-based Oracle Performance Tuning: Theory and Practice
|
Cost: |
Free
|
|
Date:
|
Dec 09, 2008
|
|
Agenda: |
5:15 – 5:30 Networking and Refreshments
5:30 – 5:45 Welcome and Peer-toPeer
5:45 – 7:15 "Oracle Database Design and Performance", presented by Graham Wood
7:15 Closing Remarks
|
Location:
|
The Hartford, Hartford Plaza CT 06115
Wallace Stevens Theater
Visit our website for details, directions and much more!
|
|
Topics: |
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. The automatic
analysis of DB Time by the Automatic Database Diagnostic Monitor (ADDM) is also
discussed. Examples usages of Enterprise Manager’s visualization of DB Time will
also be presented.
Graham Wood
Yrs Experience: 22
Job Title: Architect
Coverage: Worldwide
Graham Wood is an architect in the database development group at Oracle. Most of
his 20 years at Oracle has been spent in performance related areas, including
designing and tuning large high-performance systems, building monitoring tools
such as Statspack, and in architecting performance and scalability features into
the database itself. Most recently Graham has worked as part of the Oracle
Manageability team tasked with simplifying the process of tuning the operation
of the database which resulted in the development of AWR, ASH and ADDM to
provide automatic tuning. Graham has presented at Oracle and third party
conferences around the world primarily on topics of Oracle database design and
performance.
|
Archived Events:
|