Presentation Title: Advanced ASH Analytics: ASHmasters
Speaker: Mr Marcin Przepiorowski Oracle ACE OakTable
Company: Delphix
Presentation abstract: Learn about ASH Masters a github repository of queries against Average Active Sessions (ASH). Learn about ASH math, average active sessions and the power and pitfalls of ASH queries. ASH queries will be shown that display over database performance from on high to diving deep down into the nitty gritty of performance bottleneck's internal workings. Active Session History (ASH) is the most powerful source of performance analytic data in Oracle. Querying ASH can be difficult with a number of pitfalls but the rewards of correct data analysis of ASH are the most powerful tool a DBA has for performance analysis. Learn how to query ASH correctly and learn where to get pre-written powerful ASH queries.
Presentation begins: 08/12/2015 09:00
Presentation duration: 50
Presentation content level: 1 (1 = indepth, 5 = strategic overview)
Audience experience: Experienced/Expert
Audience function: Product Expert, Product User
Speaker biography:  I'm working with Oracle technology stack since 2001. I'm interested in two areas - high availability (DataGuard, RAC, etc) and performance monitoring and troubleshooting. For last 10 years I'm involved in OUG community and blogger community. I presented on UKOUG, Polish OUG, Irish and BGOUG conferences. I'm a proud member of OakTable Network since March 2013.
Related topics: Database: Performance & Internals
Hall: Hall 9

ashmasters_ukoug15.pdf7.8 MB04/01/2016 14:11:03