In this episode of Grey Beards [Grey Beards #10 with John Beresniewicz - YouTube], we had the privilege of chatting with John Beresniewicz, a highly talented and respected Oracle performance metrics expert. We covered a wide range of topics, including ADDM* and ADDM Spotlight [a strategic performance tool that aggregates findings from multiple AWR snapshots], and DB Time analysis for optimizing database performance. We also delved into other fascinating Oracle capabilities like Database Replay, SQL Performance Analyzer, Real Application Testing, and the utilization of SQL Warehouse to build a better picture of SQL performance and workloads; John also shared insights on using SQL_EXEC_ID to estimate average latencies for high-frequency SQL. We also touched on the use of Large Language Model Tools like Chat. Further, John enlightened us on his interest in Blockchain. Don’t miss this episode which is packed with valuable knowledge and practical tips from a true Grey Beard (minus the grey beard, which we use figuratively as a symbol of industry expertise).
*ADDM: The Automatic Database Diagnostics Monitor (ADDM) is a powerful tool in Oracle that analyzes performance data collected from the Automatic Workload Repository (AWR). It automatically identifies performance problems and provides actionable recommendations to improve database performance. By analyzing various metrics, such as CPU usage, I/O, and memory utilization, ADDM helps administrators pinpoint areas of concern and offers suggestions for optimization. It plays a crucial role in proactively diagnosing and resolving performance issues, allowing for efficient and effective management of Oracle databases.
John’s Bio
We are excited to welcome John Beresniewicz to "Grey Beards – War Stories from the Technical Trenches," where we explore the experiences and insights of esteemed professionals. Join us as we delve into John's fascinating journey, extracting valuable lessons, technical expertise, and a touch of humor along the way.
John Beresniewicz is a highly respected Oracle performance management expert with over 20 years of experience in product design and architecture. As an Architect of Enterprise Observability and Management at Oracle Corporation, he specializes in defining, architecting, and implementing observability and management solutions in the Oracle Cloud and on-premises environments. His background is in UX design, data architecture, and technical evangelism, John's expertise extends to optimizing Oracle database performance and developing visually-oriented DBA performance diagnostics. He is a co-founder of Savant Corporation, co-author of software engineering books, and holds multiple patents in performance analytics and data visualization. As a sought-after speaker, John shares his knowledge on various Oracle performance management topics, showcasing his deep understanding of ASH, AWR, Average Active Sessions, Top Activity, ADDM, and more. He has a passion for delivering exceptional results and a wealth of experience, John brings valuable insights to the technical community.