Mining the AWR v2: Trend Analysis

AWR Difference Reports are very helpful when overall performance information about two different periods needs to be compared. However, if the requirement is to review the trends of performance of a specific query, average length of a particular wait event, or difference of a specific statistic over time with a purpose of identification of peaks, the AWR Difference Reports are of little help. This presentation will concentrate on techniques of extracting information from the Automatic Workload Repository to analyze how things change over time, which is useful for both - forecasting and identification of specific time periods when issues affect specific areas of the database the most.

Thursday, 2016-11-17
09:00 am - 09:45 am
Maris Elsins is an experienced Oracle Applications DBA currently working as Lead Database Consultant at The Pythian Group, who's responsibilities also include supervising the technical solutions provided by one of Pythian's Apps DBAs teams to the clients. Maris' main areas of expertise are maintenance, troubleshooting and performance tuning of Oracle Database and e-Business Suite systems. He is a blogger and a frequent speaker at Oracle related conferences such as UKOUG, Collaborate, HotSos, Oracle OpenWorld and others. Maris is an Oracle ACE, an Oracle Certified Master. He's a coauthor of “Practical Oracle Database Appliance” (Apress, 2014) and also a member of the board at Latvian Oracle User Group (LVOUG).

These lectures could also interest you