Oracle Database 12c Performance Tuning Recipes: A Problem-Solution Approach (Paperback)

Performance problems are rarely "problems" per se. They are more often "crises" during which you’re pressured for results by a manager standing outside your cubicle while your phone rings with queries from the help desk. You won’t have the time for a leisurely perusal of the manuals, nor to lean back and read a book on theory. What you need in that situation is a book of solutions, and solutions are precisely what Oracle Database 12c Performance Tuning Recipes delivers.

Oracle Database 12c Performance Tuning Recipes is a ready reference for database administrators in need of immediate help with performance issues relating to Oracle Database. The book takes an example-based approach, wherein each chapter covers a specific problem domain. Within each chapter are "recipes," showing by example how to perform common tasks in that chapter’s domain. Solutions in the recipes are backed by clear explanations of background and theory from the author team. Whatever the task, if it’s performance-related, you’ll probably find a recipe and a solution in this book.

• Provides proven solutions to real-life Oracle performance problems
• Offers relevant background and theory to support each solution
• Gets straight to the point for when you're under pressure for results

What you’ll learn

• Optimize the use of memory and storage
• Monitor performance and troubleshoot problems
• Identify and improve poorly-performing SQL statements
• Adjust the most important optimizer parameters to your advantage
• Create indexes that get used and make a positive impact upon performance
• Automate and stabilize using key features such as SQL Tuning Advisor and SQL Plan Baselines

Who this book is for

Oracle Database 12c Performance Tuning Recipes is aimed squarely at Oracle Database administrators. The book especially appeals to those administrators desiring to have at their side a ready-to-go set of solutions to common database performance problems.

Table of Contents

1. Optimizing Table Performance
2. Choosing and Optimizing Indexes
3. Optimizing Instance Memory
4. Monitoring System Performance
5. Minimizing System Contention
6. Analyzing Operating System Performance
7. Troubleshooting the Database
8. Creating Efficient SQL
9. Manually Tuning SQL
10. Tracing SQL Execution
11. Automated SQL Tuning
12. Execution Plan Optimization and Consistency
13. Configuring the Optimizer
14. Implementing Query Hints
15. Executing SQL in Parallel

性能問題很少是實際上的「問題」。更常見的是在這種危機中，你在辦公室外面的經理的壓力下，同時接到來自幫助台的查詢電話。你沒有時間悠閒地閱讀手冊，也沒有時間坐下來讀一本理論書。在這種情況下，你需要的是一本解決方案的書籍，《Oracle Database 12c性能調優食譜》正是提供這樣的解決方案。

《Oracle Database 12c性能調優食譜》是一本針對Oracle Database性能問題需要立即幫助的數據庫管理員的參考書。本書採用基於示例的方法，每個章節涵蓋一個特定的問題領域。每個章節中都有「食譜」，通過示例展示如何在該章節的領域中執行常見任務。食譜中的解決方案由作者團隊提供清晰的背景和理論解釋。無論任務是什麼，如果與性能有關，你可能會在這本書中找到相應的食譜和解決方案。

以下是你將學到的內容：
- 優化內存和存儲的使用
- 監控性能並解決問題
- 識別和改進性能不佳的SQL語句
- 調整最重要的優化器參數以獲得優勢
- 創建被使用並對性能產生積極影響的索引
- 使用SQL調優顧問和SQL計劃基線自動化和穩定化

本書適合Oracle Database管理員閱讀。尤其適合那些希望擁有一套常見數據庫性能問題的解決方案的管理員。以下是目錄：
1. 優化表性能
2. 選擇和優化索引
3. 優化實例內存
4. 監控系統性能
5. 減少系統競爭
6. 分析操作系統性能
7. 故障排除數據庫
8. 創建高效的SQL
9. 手動調優SQL
10. 追蹤SQL執行
11. 自動化SQL調優
12. 執行計劃優化和一致性
13. 配置優化器
14. 實施查詢提示
15. 并行執行SQL