Oracle High Performance Tuning for 9i and 10g - page 1
- Table of Contents
- Table of Contents
- BackCover
- Oracle High Performance Tuning for 9i and 10g
- Preface
- Introduction
- When to Tune
- What to Tune in Production
- When to Stop Tuning in Production
- Tuning from Development to Production
- How is this Book Organized?
- Some Final Points
- What is Oracle Database 10g?
- Part I: Data Model Tuning
- Chapter 1: The Relational Database Model
- 1.1 A Layman s Approach to Normalization
- 1.2 Referential Integrity
- Chapter 2: Tuning the Relational Database Model
- 2.2 Referential Integrity and Tuning
- 2.3 Optimizing with Alternate Indexes
- 2.4 Undoing Normalization
- Chapter 3: Different Forms of the Relational Database Model
- 3.1 The Purist s Relational Database Model
- 3.2 Object Applications and the Relational Database Model
- Chapter 4: A Brief History of Data Modeling
- 4.1 The History of Data Modeling
- 4.2 The History of Relational Databases
- 4.3 The History of the Oracle Database
- 4.4 The Roots of SQL
- Part II: SQL Code Tuning
- Chapter 5: What is SQL?
- 5.1 DML and DDL
- 5.2 DML Command Syntax
- 5.3 Transaction Control
- 5.4 Parallel Queries
- Chapter 6: The Basics of Efficient SQL
- 6.1 The SELECT Statement
- 6.2 Using Functions
- 6.3 Pseudocolumns
- 6.4 Comparison Conditions
- 6.5 Joins
- 6.6 Using Subqueries for Efficiency
- 6.7 Using Synonyms
- 6.8 Using Views
- 6.9 Temporary Tables
- 6.10 Resorting to PLSQL
- 6.11 Replacing DELETE with TRUNCATE
- 6.12 Object and Relational Conflicts
- Chapter 7: Common Sense Indexing
- 7.1 What and How to Index
- 7.2 Types of Indexes
- 7.3 Types of Indexes in Oracle Database
- 7.4 Tuning BTree Indexes
- 7.5 Summarizing Indexes
- Chapter 8: Making SQL Efficient in Oracle Database
- 8.1 What is the Parser?
- 8.2 What is the Optimizer?
- 8.3 How Best to Access Data in the Database
- 8.4 Rule-versus Cost-Based Optimization
- 8.5 Data Access Methods
- 8.6 Sorting
- 8.7 Special Cases
- 8.8 Overriding the Optimizer using Hints
- Chapter 9: How to Find Problem Queries
- 9.1 Tools to Detect Problems
- 9.2 EXPLAIN PLAN
- 9.3 SQL Trace and TKPROF
- 9.4 TRCSESS
- 9.5 Autotrace
- 9.6 Oracle Database Performance Views for Tuning SQL
- Chapter 10: Tuning SQL with Oracle Enterprise Manager
- Part III: Physical and Configuration Tuning
- Chapter 11: Installing Oracle and Creating a Database
- 11.2 Basic Configuration
- 11.3 Creating a Database
- Chapter 12: Tuning Oracle Database File Structures
- 12.1 Oracle Database Architecture and the Physical Layer
- 12.2 Tuning and the Logical Layer
- Chapter 13: Object Tuning
- 13.1 Tables
