JUL
21

VIC Performance Diagnostics – How To Correctly Use AWR Reports

Where: Melbourne: Oracle, Level 5, 417 St. Kilda Road
When: Thursday, July 21, 2016 08:30am - 01:30pm

Back by popular demand, we invite you to the upcoming “Let’s Talk Oracle Database” in Melbourne on Thursday, 21 July 2016.
 
Session Overview:
 
I often get called in by customers to determine and address the root cause of database performance issues. Depending on the issue, a request for a simple Automatic Workload Repository (AWR) report is often sufficient to accurately diagnose the root problem(s). However, many DBAs find AWR reports daunting as they contain so much database diagnostic information, they don’t even know where to begin to find the truly useful information.
 
In this session, I begin by discussing the basic concepts of response times, DB times, the Oracle Wait Interface and how to focus on what is truly important. I then look at how to best read an AWR report to quickly go to the most relevant sections that detail any specific issues. I also discuss a general tuning and diagnostic methodology that ensures one can quickly determine whether an AWR report will indeed be sufficient and how to accurately and consistently use the AWR report to pinpoint and determine root causes for global database performance issues. We’ll go through a number of actual “real-life” examples that highlight various performance issues and how one accurately determines the actual root issues through an appropriate AWR report.
 
Time permitting, we’ll go through some other useful diagnostic tools such as the AWR Warehouse, Automatic Database Diagnostic Monitor (ADDM), Active Session History (ASH) and SQL Extended Tracing and scenarios when they can prove to be invaluable in addressing database performance issues.
 
Presenter: Richard Foote, Database Guru and former Oracle ACE Director
Who Should Attend: Oracle DBAs, Developers, other technical professionals
Time: 8:30am – 1:30pm (Breakfast and Lunch provided)
Date: Thursday, 21 July 2016
Venue: Oracle, Level 5, 417 St. Kilda Road, Melbourne

Click here to register, include names of those who want to attend and any dietary requirements.

 
Agenda
 
8:30 - 9:00am Registration and coffee
9:00 - 10:30am Performance Diagnostics - Part I
10:30 - 11:00am Break
11:00 - 12:30pm Performance Diagnostics – Part II
12:30 – 1:30pm Lunch, Networking and informal Q&A

 

 


Please support the AUSOUG partners as they support you.

Silver Partner

Silver Partner

Contact vicepresident@ausoug.org.au to become a VIC State Partner