High-Performance Oracle: Proven Methods for Achieving Optimum Performance and Av

Description:

"Geoff Ingram has met the challenge of presenting the complex process of managing Oracle performance. This book can support every technical person looking to resolve Oracle8i and Oracle9i performance issues."
-Aki Ratner, President, Precise Software Solutions
Ensuring high-performance and continuous availability of Oracle software is a key focus of database managers. At least a dozen books address the subject of "performance tuning"-- that is, how to fine-tune the Oracle database for its greatest processing efficiency. Geoff Ingram argues that this approach simply isn't enough. He believes that performance needs to be addressed right from the design stage, and it needs to cover the entire system--not just the database.
High-Performance Oracle is a hands-on book, loaded with tips and techniques for ensuring that the entire Oracle database system runs efficiently and doesn't break down. Written for Oracle developers and DBAs, and covering both Oracle8i and Oracle9i, the book goes beyond traditional performance-tuning books and covers the key techniques for ensuring 24/7 performance and availability of the complete Oracle system.
The book provides practical solutions for:
* Choosing physical layout for ease of administration and efficient use of space
* Managing indexes, including detecting unused indexes and automating rebuilds
* SQL and system tuning using the powerful new features in Oracle9i Release 2
* Improving SQL performance without modifying code
* Running Oracle Real Application Clusters (RAC) for performance and availability
* Protecting data using Recover Manager (RMAN), and physical and logical standby databases
The companion Web site provides the complete source code for examples in the book, updates on techniques, and additional documentation for optimizing your Oracle system.

 

Table of Contents:

Dedication.

Acknowledgements.

Introduction.

PART ONE: FUNDAMENTALS OF AN ORACLE CONFIGURATION.

Chapter 1- Installing Oracle.

Chapter 2- Database Creation.

Chapter 3- Configuring Oracle Networking.

Chapter 4- Environment Standards and Tools.

Chapter 5- Securing your Database.

PART TWO: DESIGNING FAST AND SUPPORTABLE APPLICATIONS.

Chapter 6- Designing Supportable Applications.

Chapter 7- Choosing Third Party Software.

PART THREE: PERFORMANCE MANAGEMENT AND TUNING TECHNIQUES.

Chapter 8- End-to-End Performance Management.

Chapter 9- Fundamentals of SQL Tuning.

Chapter 10- Collecting and Using Optimizer Statistics.

Chapter 11- Partitioning.

Chapter 12- Managing Indexes.

Chapter 13- Managing Space Growth.

Chapter 14- Stress Testing and Benchmarks.

Chapter 15- Server Consolidation and Resource Management.

Chapter 16- Selecting and Using Performance Management Tools.

PART FOUR: Backup, Restore, and Recovery.

Chapter 17- Fundamentals of Oracle Recovery.

Chapter 18- Backup and Recovery Using RMAN.

Chapter 19- Backup and Restore Using Export and Import.

PART FIVE: HIGH AVAILABILITY SOLUTIONS.

Chapter 20- VERITAS High Availability for Oracle.

Chapter 21- Oracle Replication.

Chapter 22- Oracle Real Application Clusters.

Chapter 23- Protecting Data Using Standby Databases.

PART SIX: Maintaining the Oracle System.

Chapter 24- Guidelines for Healthchecks and Monitoring.

Chapter 25- Auditing Techniques.

Chapter 26- Migration and Upgrade.

Chapter 27- Working Effectively with Oracle Support.

Chapter 28- Troubleshooting Oracle DBMS Problems.

Index.

描述：
Geoff Ingram成功地呈現了管理Oracle性能的複雜過程。這本書可以支持每個尋求解決Oracle8i和Oracle9i性能問題的技術人員。-Aki Ratner，Precise Software Solutions總裁。確保Oracle軟件的高性能和持續可用性是數據庫管理人員的重點關注。至少有十幾本書涉及“性能調整”這個主題，即如何對Oracle數據庫進行微調以實現最大的處理效率。Geoff Ingram認為這種方法根本不夠。他認為性能需要從設計階段開始解決，並且需要涵蓋整個系統，而不僅僅是數據庫。《高性能Oracle》是一本實用的書，充滿了確保整個Oracle數據庫系統運行高效且不會崩潰的技巧和技術。這本書針對Oracle開發人員和數據庫管理員，涵蓋了Oracle8i和Oracle9i，超越了傳統的性能調整書籍，涵蓋了確保全面Oracle系統24/7性能和可用性的關鍵技術。本書提供了以下實用解決方案：
* 選擇物理布局以便於管理和有效使用空間
* 管理索引，包括檢測未使用的索引和自動重建
* 使用Oracle9i Release 2中的強大新功能進行SQL和系統調整
* 在不修改代碼的情況下改善SQL性能
* 運行Oracle實時應用集群（RAC）以實現性能和可用性
* 使用恢復管理器（RMAN）和物理和邏輯備用數據庫保護數據
附帶的網站提供了書中示例的完整源代碼，技術更新以及優化Oracle系統的其他文檔。

目錄：
致謝
引言
第一部分：Oracle配置基礎
第1章- 安裝Oracle
第2章- 數據庫創建
第3章- 配置Oracle網絡
第4章- 環境標準和工具
第5章- 保護您的數據庫
第二部分：設計快速且可支持的應用程序
第6章- 設計可支持的應用程序
第7章- 選擇第三方軟件
第三部分：性能管理和調優技術
第8章- 端到端性能管理
第9章- SQL調優基礎
第10章- 收集和使用優化器統計信息
第11章- 分區
第12章- 管理索引
第13章- 管理空間增長
第14章- 壓力測試和基準測試
第15章- 服務器合併和資源管理