商品描述
Use an innovative approach that relies on big data and advanced analytical techniques to analyze and improve Oracle Database performance. The approach used in this book represents a step-change paradigm shift away from traditional methods. Instead of relying on a few hand-picked, favorite metrics, or wading through multiple specialized tables of information such as those found in an automatic workload repository (AWR) report, you will draw on all available data, applying big data methods and analytical techniques to help the performance tuner draw impactful, focused performance improvement conclusions.
This book briefly reviews past and present practices, along with available tools, to help you recognize areas where improvements can be made. The book then guides you through a step-by-step method that can be used to take advantage of all available metrics to identify problem areas and work toward improving them. The method presented simplifies the tuning process and solves the problem of metric overload.
You will learn how to: collect and normalize data, generate deltas that are useful in performing statistical analysis, create and use a taxonomy to enhance your understanding of problem performance areas in your database and its applications, and create a root cause analysis report that enables understanding of a specific performance problem and its likely solutions.
- Collect and prepare metrics for analysis from a wide array of sources
- Apply statistical techniques to select relevant metrics
- Create a taxonomy to provide additional insight into problem areas
- Provide a metrics-based root cause analysis regarding the performance issue
- Generate an actionable tuning plan prioritized according to problem areas
- Monitor performance using database-specific normal ranges
Who This Book Is For
Professional tuners: responsible for maintaining the efficient operation of large-scale databases who wish to focus on analysis, who want to expand their repertoire to include a big data methodology and use metrics without being overwhelmed, who desire to provide accurate root cause analysis and avoid the cyclical fix-test cycles that are inevitable when speculation is used
商品描述(中文翻譯)
使用一種創新的方法，依賴大數據和先進的分析技術來分析和改善 Oracle Database 的性能。本書中所使用的方法代表了一種從傳統方法中脫離的顯著變革。與其依賴少數精心挑選的指標，或是在自動工作負載庫（AWR）報告中翻閱多個專門的信息表格，不如利用所有可用數據，應用大數據方法和分析技術，幫助性能調優者得出有影響力且專注的性能改進結論。
本書簡要回顧了過去和現在的實踐以及可用的工具，幫助您識別可以改進的領域。然後，本書引導您通過一個逐步的方法，利用所有可用的指標來識別問題區域並朝著改善的方向努力。所提出的方法簡化了調優過程，解決了指標過載的問題。
您將學習如何：收集和標準化數據，生成在進行統計分析時有用的增量，創建和使用分類法以增強您對數據庫及其應用程序中問題性能區域的理解，並創建一份根本原因分析報告，以便理解特定性能問題及其可能的解決方案。
您將學到的內容：
- 從各種來源收集和準備指標以進行分析
- 應用統計技術選擇相關指標
- 創建分類法以提供對問題區域的額外見解
- 提供基於指標的根本原因分析，針對性能問題
- 生成根據問題區域優先排序的可行調優計劃
- 使用數據庫特定的正常範圍監控性能
本書適合對象：
專業調優者：負責維護大規模數據庫的高效運行，想要專注於分析，想要擴展其技能以包括大數據方法論並使用指標而不感到不知所措，渴望提供準確的根本原因分析並避免在使用推測時不可避免的循環修復-測試循環。
