Presentation Title: Identification of Performance Problems Without the Diagnostic Pack
Speaker: Mr Christian Antognini Oracle ACE Director OakTable
Presentation abstract: There will be a 10 minute UKOUG Welcome Video between 08:50 - 09:00 follwed by this session

Diagnostic Pack, which is an option available for the Enterprise Edition of Oracle Database only, gives access to a number of dynamic performance views and to the Automatic Workload Repository (AWR). Both are very useful for the identification of performance problems. On the one hand, dynamic performance views are mainly used for the analysis of performance problems while they are occurring. On the other hand, AWR is aimed at the analysis of performance problems that occurred in the past. The aim of this presentation is to describe how to perform analyses similar to those that can be carried out with the tools provided by the Diagnostic Pack even if you don’t have it.
Presentation begins: 06/12/2016 09:00
Presentation duration: 60
Presentation content level: 2 (1 = indepth, 5 = strategic overview)
Audience experience: Intermediate
Audience function: Product Expert
Speaker biography:  Since 1995, Christian Antognini has focused on understanding how the Oracle database engine works. His main interests include logical and physical database design, the integration of databases with Java applications, the query optimizer and basically everything else related to application performance management. He is currently working as a senior principal consultant and trainer at Trivadis in Zürich, Switzerland. If Christian is not helping one of his customers get the most out of Oracle, he is somewhere lecturing on application performance management or new Oracle Database features for developers. In addition to classes and seminars organized by Trivadis, he regularly presents at conferences and user-group meetings. He is a proud member of the OakTable Network and an Oracle ACE Director. Christian is the author of Troubleshooting Oracle Performance (Apress, 2008/2014) and the co-author of Der Oracle DBA (Hanser, 2011).
Related topics: Database: Performance & Internals, Database: Standard Edition (User Stories, Limits & Benefits)
Hall: Hall 5

NoDiagnosticPack_UKOUG_2016.pdf872 KB06/12/2016 12:15:59