Oracle Performance Tuning 101
暫譯: Oracle 性能調優 101
Gaja Krishna Vaidyanatha, Kirtikumar Deshpande, John A. Kostelac
- 出版商: McGraw-Hill Education
- 出版日期: 2001-05-29
- 售價: $1,900
- 貴賓價: 9.5 折 $1,805
- 語言: 英文
- 頁數: 404
- 裝訂: Paperback
- ISBN: 0072131454
- ISBN-13: 9780072131451
-
相關分類:
Oracle
海外代購書籍(需單獨結帳)
買這商品的人也買了...
-
$1,580$1,501 -
$680$537 -
$980$774 -
$970Introduction to Algorithms, 2/e
-
$500$250 -
$950$931 -
$580$458 -
$1,274Computer Architecture: A Quantitative Approach, 3/e(精裝本)
-
$1,078Computing Concepts With Java Essentials, 3/e
-
$1,029Operating System Concepts, 6/e (Windows XP Update)
-
$450$351 -
$690$587 -
$780$741 -
$780CMMI: Guidelines for Process Integration and Product Improvement (Harcover)
-
$590$466 -
$480$374 -
$690$538 -
$680$537 -
$980$960 -
$1,360$1,292 -
$750$638 -
$2,250$2,138 -
$560$476 -
$850$723 -
$650$507
商品描述
Learn to optimize and fine-tune your Oracle systems overall performance
Implement tuning solutions using the proven methodology found inside Oracle Performance Tuning 101 gives you step-by-step practical advice for removing bottlenecks, minimizing downtime, and increasing overall system performance. Youll also get tips for identifying Oracles current bottlenecks, prioritizing and performing tuning operations, writing optimal SQL, interpreting statistics, and much more. Written in a clear and engaging style, this book explains how to manage the tuning efforts of various components of your entire system in a methodical fashion, eliminating all guesswork.
- Understand the key components of a tuning methodology
- Set performance objectives, establish goals, and cease efforts when goals
are met
- Learn how to generate well-written SQL commandsand know how to
recognize poorly written SQL
- Tune and manage various components of the Oracle Instance
- Use meaningful Oracle initialization parameter settings
- Implement proactive management of space in the Oracle database
- Understand I/O tuning with extensive coverage on implementing RAID on
Oracle
- Get details on operating system tuning for Solaris, HP-UX, AIX, and
Windows NT
Every chapter includes one or more myths and folklores about the topic, examples, and an In a Nutshell section--all geared to reinforce the knowledge youve acquired.
Contents
Part I: The Method.
Chapter 1:
Introduction to Oracle Peformance Management.
Chapter 2:
The Method Behind the Madness.
Part II: Application
Tuning.
Chapter 3: Application Tuning: Issues that
Concern a DBA.
Chapter 4: Application Tuning: Tracking
Down Bad SQL.
Part III: Instance and Database
Tuning.
Chapter 5: Instance Tuning: The Shared Pool
Area.
Chapter 6: Instance Tuning: The Database Buffer
Cache.
Chapter 7: Instance Tuning: The Redo Log Buffer
& Miscellaneous Tuning.
Chapter 8: Database
Tuning.
Part IV: Specialized Tuning.
Chapter 9: Parallel Query Tuning.
Chapter 10: Contention
Tuning.
Part V: Environment Tuning.
Chapter 11: I/O Tuning.
Chapter 12: Operating System
Tuning.
Chapter 13: Wrapping It Up.
Part
VI: Appendixes:
Appendix A:
Glossary.
Appendix B: More Tips &
Resources.
Appendix C:
References.
商品描述(中文翻譯)
學習優化和微調您的 Oracle 系統整體性能
使用《Oracle Performance Tuning 101》內部的經驗方法實施調整解決方案,為您提供逐步的實用建議,以消除瓶頸、最小化停機時間並提高整體系統性能。您還將獲得識別 Oracle 當前瓶頸、優先排序和執行調整操作、撰寫最佳 SQL、解釋統計數據等方面的提示。本書以清晰且引人入勝的風格撰寫,解釋了如何以系統化的方式管理整個系統各個組件的調整工作,消除所有的猜測。
- 了解調整方法的關鍵組件
- 設定性能目標,建立目標,並在達成目標時停止努力
- 學習如何生成撰寫良好的 SQL 命令,並知道如何識別撰寫不佳的 SQL
- 調整和管理 Oracle 實例的各個組件
- 使用有意義的 Oracle 初始化參數設置
- 實施 Oracle 數據庫的主動空間管理
- 理解 I/O 調整,並廣泛涵蓋在 Oracle 上實施 RAID
- 獲取有關 Solaris、HP-UX、AIX 和 Windows NT 的操作系統調整的詳細信息
每一章都包括一個或多個與主題相關的神話和民間故事、示例,以及一個「簡而言之」的部分——所有這些都旨在加強您所獲得的知識。
內容
**第一部分:方法。**
第 1 章:Oracle 性能管理簡介。
第 2 章:瘋狂背後的方法。
**第二部分:應用調整。**
第 3 章:應用調整:DBA 關心的問題。
第 4 章:應用調整:追蹤不良 SQL。
**第三部分:實例和數據庫調整。**
第 5 章:實例調整:共享池區域。
第 6 章:實例調整:數據庫緩衝區快取。
第 7 章:實例調整:重做日誌緩衝區及其他調整。
第 8 章:數據庫調整。
**第四部分:專門調整。**
第 9 章:並行查詢調整。
第 10 章:競爭調整。
**第五部分:環境調整。**
第 11 章:I/O 調整。
第 12 章:操作系統調整。
第 13 章:總結。
**第六部分:附錄:**
附錄 A:術語表。
附錄 B:更多提示與資源。
附錄 C:參考文獻。