jump to navigation

Announcement: AUSOUG 1 Day Oracle Database AWR/Statspack Workshops with Richard Foote May 20, 2021

Posted by Richard Foote in AWR Reports, Oracle, Performance Tuning.
add a comment

It’s with much excitement that I announce a couple of in-person workshops I’ll be running in the coming months in conjunction with the Australian Oracle User Group (AUSOUG). The dates and locations are:

These will be 1 day workshops that discuss in detail when and how to effectively interpret and diagnose performance issues using Oracle Database AWR/Statspack Reports.

When an application suddenly runs “slow” or when people start complaining about the “poor performance” of the database, there’s often 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.

Both sessions will be followed by an end-of-day networking session.

AUSOUG are hosting these workshops at a very special price for their members, although it’s possible for non-members to also register (see link below):

AUSOUG One Day AWR/Statspack Workshop with Richard Foote


Places will be strictly limited to provide those in attendance plenty of time for questions and to have their AWR/Statspack reports anaylsed as part of the workshop. So please book early to avoid disappointment and to take advantage of the extra special early bird rate. At just $200 for AUSOUG members, it’s the best value training you will get in a very long time… 🙂

Future workshops may be added in the coming weeks, please stay tuned.