Email RIS file
Bookmark
Report an Issue

Oracle high performance tuning for 9i and 10g / Gavin Powell

Author
Powell, Gavin
Published
Amsterdam ; Boston : Elsevier/Digital Press, [2004]
Copyright Date
©2004
Physical Description
1 online resource (xxxiv, 738 pages) : illustrations
Access Online

Availability

I Want It
I Want It

Finding items...

Contents
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., and 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.
Summary
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 application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model. Poorly written SQL code is often a culpri.
Subject(s)
ISBN
9780080513294 (electronic bk.)
0080513298 (electronic bk.)
1282540149
9781282540149
View MARC record | catkey: 43346138