Troubleshooting Oracle Performance, 2/e (Paperback)

Troubleshooting Oracle Performance, 2nd Edition is your systematic guide to diagnosing and resolving performance problems in database-backed applications involving Oracle's database engine. Christian Antognini brings a decade and a half experience to his topic. His first edition is one of the most well-respected books in its field. This second edition has been rigorously updated to cover the latest developments in Oracle Database 11g Release 2 through Oracle Database 12c.

What do you do when your database application isn’t running fast enough? You troubleshoot, of course. Finding the slow part of an application is often the easy part of the battle. It’s finding a solution that’s difficult. Troubleshooting Oracle Performance, 2nd Edition helps by providing a systematic approach to addressing the underlying causes of poor database application performance. The author freely shares his experience while explaining the underlying foundations of how SQL statements are executed by the Oracle database engine. You'll be able to draw a solid foundation of theory and shared experience as you face head-on the performance challenges in your daily work.

• Written for developers by an application developer who has learned by doing
• Gives a systematic approach to solving database application performance problems
• Helps you plan for performance as you would for any other application requirement

What you’ll learn

• Systematically identify performance problems
• Configure the query optimizer to meet performance goals
• Read and recognize inefficient execution plans
• Minimize the impact of parsing upon performance
• Optimize data access, joins, and the physical design of your database
• Improve performance through parallel processing, materialized views, and result caching
• Apply SQL tuning techniques such as hints, SQL profiles, stored outlines, and SQL plan baselines
• Reduce inefficiencies from too much procedural code

Who this book is for

Troubleshooting Oracle Performance, Second Edition is targeted at application developers and database administrators involved in troubleshooting performance problems in Oracle-based applications.

Table of Contents

Part I: Foundations

1. Performance Problems
2. Key Concepts

Part II: Identification

3. Analysis of Reproducible Problems
4. Real-Time Analysis of Irreproducible Problems
5. Postmortem Analysis of Irreproducible Problems

Part III: Query Optimizer

6. Introducing the Query Optimizer
7. System Statistics
8. Object Statistics
9. Configurincg the Query Optimizer
10. Execution Plans

Part IV: Optimization

11. SQL Tuning Techniques
12. Parsing
13. Optimizing Data Access
14. Optimizing Joins
15. Beyond Data Access and Join Optimization
16. Optimizing the Physical Design

《故障排除 Oracle 效能，第二版》是一本系統性指南，用於診斷和解決涉及 Oracle 數據庫引擎的數據庫支持應用程序的性能問題。Christian Antognini在這個主題上擁有十五年的經驗。他的第一版是該領域中最受尊敬的書籍之一。這第二版已經經過嚴格更新，以涵蓋 Oracle Database 11g Release 2 到 Oracle Database 12c 的最新發展。

當你的數據庫應用程序運行速度不夠快時，你會怎麼做？當然是進行故障排除。找到應用程序的緩慢部分通常是戰鬥中最容易的部分。但找到解決方案卻很困難。《故障排除 Oracle 效能，第二版》通過提供一種系統性的方法來解決導致數據庫應用程序性能不佳的根本原因來幫助你。作者在解釋 Oracle 數據庫引擎如何執行 SQL 語句的基礎原理時，自由地分享了他的經驗。在面對日常工作中的性能挑戰時，你將能夠建立堅實的理論基礎和共享經驗。

本書針對開發人員撰寫，作者是一位實踐中學習的應用程序開發人員。它提供了一種系統性的方法來解決數據庫應用程序性能問題。它幫助你像處理其他應用程序需求一樣計劃性能。

你將學到什麼：
- 系統性地識別性能問題
- 配置查詢優化器以達到性能目標
- 讀取和識別低效的執行計劃
- 減少解析對性能的影響
- 優化數據訪問、連接和數據庫的物理設計
- 通過並行處理、物化視圖和結果緩存來提高性能
- 應用 SQL 調優技術，如提示、SQL 設置文件、存儲大綱和 SQL 計劃基線
- 減少過多程序代碼的效率低下

本書的讀者：
《故障排除 Oracle 效能，第二版》針對參與解決 Oracle 應用程序性能問題的應用程序開發人員和數據庫管理員。

目錄：
第一部分：基礎
1. 效能問題
2. 關鍵概念

第二部分：識別
3. 可重現問題的分析
4. 不可重現問題的實時分析
5. 不可重現問題的事後分析

第三部分：查詢優化器
6. 介紹查詢優化器
7. 系統統計信息
8. 對象統計信息
9. 配置查詢優化器
10. 執行計劃

第四部分：優化
11. SQL 調優技術
12. 解析
13. 優化數據訪問
14. 優化連接
15. 超越數據訪問和連接優化
16. 優化物理設計