Oracle Performance Tuning for 10gR2.

A completely revised version containing updates through to Oracle10gR2. Still includes critical 9i features.

Saved in:
Bibliographic Details
Main Author: Powell, Gavin JT
Format: eBook
Language:English
Published: Burlington : Elsevier, 2006.
Subjects:
Online Access:Click for online access
Table of Contents:
  • Front Cover; Oracle ® Performance Tuning for 10gR2; Copyright Page; Contents; Preface; Introduction; Part I: Data Model Tuning; Chapter 1. The Relational Database Model; Chapter 2. Tuning the Relational Database Model; Chapter 3. Different Forms of the Relational Database Model; Chapter 4. A Brief History of Data Modeling; Part II: SQL Code Tuning; Chapter 5. What Is SQL?; Chapter 6. The Basics of Efficient SQL; Chapter 7. Advanced Concepts of Efficient SQL; Chapter 8. Common-Sense Indexing; Chapter 9. Oracle SQL Optimization and Statistics; Chapter 10. How Oracle SQL Optimization Works.
  • Chapter 11. Overriding Optimizer Behavior Using HintsChapter 12. How to Find Problem Queries; Chapter 13. Automated SQL Tuning; Part III: Physical and Configuration Tuning; Chapter 14. Tuning Oracle Database File Structures; Chapter 15. Object Tuning; Chapter 16. Low-Level Physical Tuning; Chapter 17. Hardware Resource Usage Tuning; Chapter 18. Tuning Network Usage; Chapter 19. Oracle Partitioning and Parallelism; Part IV: Tun.