Presentation Title: Oracle Optimized- AWR, ASH & ADDM Features
Speaker: Ms Kellyn Pot'Vin-Gorman
Company: Delphix
Presentation abstract: The Automatic Workload Repository, (AWR) and Active Session History, (ASH) are the defacto choice of any optimization DBA when investigating performance issues in Oracle.

With the addition of the Automatic Diagnostic Database Monitor, (ADDM) comparison reports and other new features, we’re able to add a whole new level of information to diagnosing issues.

With the introduction of Database 12c Multi-tenant, there were new challenges introduced with pluggable databases and how to diagnose issues and report on problems.

This session will dig in deep to the new additions to the AWR and ASH reports, along with the benefits of advanced investigation, trouble-shooting and diagnostics to show the power of the “always- on” approach of the AWR for the DBA who requires data behind their findings to ensure they never assume or guess, which is the first step to losing one’s credibility.

Presentation begins: 04/12/2017 12:35
Presentation duration: 50
Presentation content level: 2 (1 = indepth, 5 = strategic overview)
Audience experience: Experienced/Expert
Audience function: Product Expert, Product User
Speaker biography:  Kellyn Pot’Vin-Gorman is a member of the Oak Table Network and an Oracle ACE Director alumni. She is the Technical Intelligence Manager and Evangelist for the Office of CTO at Delphix, a company recognized for it's impressive virtualization and data masking environment capabilities. Kellyn is known for her extensive work with virtualization, Enterprise Manager, shell and python scripting, environment optimization tuning, automation and cloud initiatives. Her blog, and social media activity under her handle, DBAKevlar is well respected for her insight and content. She is the lead author on a number of technical books, hosts webinars for numerous technical groups and has presented at numerous Oracle conferences, like Oracle Open World, HotSos, Collaborate and KSCOPE. She also speaks on SQL server at SQL Saturday events, along with other technologies, including, but not limited to- Agile, DevOps and Test Data Management in the US and Europe.
Related topics: Database: Performance & Internals
Hall: Hall 1

AWR_ASH_1017_(1).pdf9.7 MB07/11/2017 11:15:39