When an application suddenly runs “slow” or when people start complaining about the “poor performance” of the database, there’s often some uncertainty in how to most quickly and most accurately determine the “root” cause of any such slowdown and effectively address any associated issues. One of the available tools in the DBA toolkit is the Automatic Workload Repository (AWR) Report, but many struggle to determine if it’s an appropriate report for the issue at hand and then how to read, decipher, and extract any useful information from the wealth of database diagnostic information available in AWR reports.
In this workshop, we explore a Tuning Methodology that helps Oracle professionals to both quickly and reliably determine if an AWR (or Statspack) report is the correct tool to use in determining the actual root causes of Oracle database performance issues. Looking at several real-world scenarios, this workshop will show participants when to consider using AWR reports and then how to diagnose performance issues confidently and reliably by extracting the relevant details from such AWR reports. Accurately determining the root causes of performance issues ensures the effectiveness and timeliness of any applied resolutions.
Participants will also be able to submit their own database AWR reports for analysis during the workshop and using the taught methodologies and techniques, identify any global performance issues within their own databases.
Study Guides Included.
When and Where:
Two locations – starting at 9.00AM and concluding at 5.00PM
Melbourne: Thursday 15th July 2021
Perth: Thursday, 12th August 2021
Limited places – first in, best dressed!
Early Bird Ticket Prices
AUSOUG Members – $200
Non-members – $500
Ticket Prices after Early Bird
AUSOUG Members – $300
Non-members – $600
(includes lunch, light refreshments and an end-of-day networking session)
Melbourne – Early Bird ends on 2nd July 2021
Perth – Early Bird ends on 19th July 2021
Become an AUSOUG Individual/Corporate member to get your ticket at Member’s price @ https://www.ausoug.org.au/membership/