If you are an Oracle database administrator (DBA) who often faces intense performance issues and needs a systematic and effective way to diagnose and resolve them, then you might want to check out the book Oracle Performance Firefighting by Craig Shallahamer. This book is aimed at helping you to confidently and effectively operate in intense performance firefighting situations. It covers topics such as data collection, diagnosis, analysis, presentation, Oracle internals, and anticipating solution impact.
The book is divided into four parts: Part I introduces the firefighting process and the tools needed for data collection; Part II explains how to diagnose the root cause of performance problems using various methods such as wait event analysis, time-based analysis, active session history (ASH), and workload characterization; Part III dives deep into Oracle internals and shows how to use them to understand performance behavior and validate diagnosis; Part IV discusses how to present the findings and recommendations in a clear and convincing way, as well as how to estimate the impact of the proposed solutions.
The book is full of diagrams, graphs, experimental results, and real-life examples that illustrate the concepts and techniques. The author also shares his insights and tips from his extensive experience as an Oracle performance consultant. The book is written in a clear and engaging style that makes it easy to follow and learn from. The book is suitable for both beginners and advanced Oracle DBAs who want to improve their firefighting skills and learn from one of the true Oracle performance masters.
You can find more information about the book and order it from the author's website [here]. You can also read some customer reviews on Amazon [here] or Google Books [here].
6500f7198a