Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach (Paperback)

Sam Alapati

  • 出版商: Apress
  • 出版日期: 2011-08-23
  • 售價: $2,530
  • 貴賓價: 9.5$2,404
  • 語言: 英文
  • 頁數: 592
  • 裝訂: Paperback
  • ISBN: 1430236620
  • ISBN-13: 9781430236627
  • 相關分類: Oracle資料庫
  • 海外代購書籍(需單獨結帳)

買這商品的人也買了...

相關主題

商品描述

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 11g Performance Tuning Recipes delivers.

Oracle Database 11g 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
  • Written by a team of experienced database administrators successful in their careers

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 11g 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 11g性能調整食譜》正是提供這樣的解決方案。

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

以下是本書的特點:
- 提供了解決真實Oracle性能問題的成熟解決方案
- 提供相關的背景和理論來支持每個解決方案
- 由一個成功的資料庫管理員團隊撰寫

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

本書適合以下讀者:
《Oracle Database 11g性能調整食譜》專為Oracle資料庫管理員而設計。本書特別適合那些希望擁有一套解決常見資料庫性能問題的解決方案的管理員。

目錄:
1. 優化表性能
2. 選擇和優化索引
3. 優化實例內存
4. 監控系統性能
5. 減少系統競爭
6. 分析操作系統性能
7. 故障排除資料庫
8. 創建高效的SQL
9. 手動調整SQL
10. 追蹤SQL執行
11. 自動化SQL調整
12. 執行計劃優化和一致性
13. 配置優化器
14. 實施查詢提示
15. 平行執行SQL