Oracle high performance tuning for 9i and 10g /
There are three parts to tuning an Oracle database: data modeling, SQL code tuning and physical database configuration. A data model contains tables and relationships between tables. Tuning a data model involves normalization and de-normalization. Different approaches are required depending on the a...
| Основен автор: | Powell, Gavin. |
|---|---|
| Формат: | Електронна книга |
| Език: | English |
| Публикувано: |
Amsterdam ; Boston :
Elsevier/Digital Press,
℗♭2004.
|
| Предмети: | |
| Онлайн достъп: |
http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=320842 |
| Подобни документи: |
Print version::
Oracle high performance tuning for 9i and 10g. |
Съдържание:
- Front Cover; Oracle℗ʼ High Performance Tuning for 9i and 1og; Copyright Page; Contents; Contents at a glance; Preface; Introduction; A Tuning Environment; 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.1 Normalization and Tuning.
- 2.2 Referential Integrity and Tuning2.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 SQL6.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 PL/SQL; 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 10g TRCSESS; 9.5 Autotrace; 9.6 Oracle Database Performance Views for Tuning SQL; Chapter 10. Tuning SQL with Oracle Enterprise Manager; 10.1 The Tuning Pack; Part III: Physical and Configuration Tuning; Chapter 11. Installing Oracle and Creating a Database.
- 11.1 Installing Oracle Database11.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; 13.2 Indexes; 13.3 Index-Organized Tables and Clusters; 13.4 Sequences; 13.5 Synonyms and Views; 13.6 10g The Recycle Bin; Chapter 14. Low-Level Physical Tuning; 14.1 What is the High Water Mark?; 14.2 Space Used in a Database; 14.3 What are Row Chaining and Row Migration?; 14.4 Different Types of Objects.