Sunday, January 24, 2021
Let's Build Something:
Building Your Own ASH Toolkil
Craig Shallahamer, Co-owner
Let's build something... of value! ASH provides Oracle DBAs with an amazing set of performance data. Because ASH analysis is based on statistics, many DBAs shy away from ASH or use it inappropriately. But once you're in-the-know along with basic dimensional analysis, your performance tuning potential becomes scary-strong.
In this session I'll show you how to build four highly flexible ASH-based scripts; summary, top wait, top cpu and session time-line. I'll even demo the scripts I just created on a real Oracle workload! Whether you use these script or not, you will have a very deep understanding about ASH and how to effectively use it. Plus, some very cool SQL*Plus script build tips.
S I T U A T I O N
• ASH data is available
• DBAs are not sure what the data really means
• The available tools seem cryptic and complicated
• The result is a lack of solid performance improving solutions
O B J E C T I V E S
• Let's Build Something... Useful!
• Why ASH is different, powerful and dangerous
• How ASH and a Time-Based Analysis support each other
• From the ground up, build an Oracle instance profile tool based on ASH
Craig is a long time Oracle DBA (1989) who specializes in Oracle database performance and started the OraPub.com website in 1995. Craig is also an Oracle ACE Director, performance researcher and blogger, consultant, author of two books (Oracle Performance Firefighting, Forecasting Oracle Performance), an enthusiastic conference speaker, and a passionate teacher to thousands of Oracle professionals in 30 countries. He is the founder and president of OraPub, creator of the performance analysis tool, Stori, and clearly pushes the teaching envelope with his online seminars! His blog, A Wider View, is where to find his most recent public performance research.
Craig grew up in Arcadia, CA and is an economics and management information systems graduate from Cal Poly, San Luis Obispo (where he met his lovely wife, Katrina). He enjoys riding his Honda VFR 800 Interceptor on the winding roads of Oregon. He can be contacted at firstname.lastname@example.org, @CShallahamer, LinkedIn and Xing.