---

Oracle High Performance Tuning for 9i and 10g

ISBN: 1555583059
EAN: 2147483647

Year: 2003
Pages: 164

Authors: Gavin JT Powell

BUY ON AMAZON

• 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
• 13.2 Indexes
• 13.3 Index-Organized Tables and Clusters
• 13.4 Sequences
• 13.5 Synonyms and Views
• 13.6 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
• 14.5 How Much Block and Extent Tuning?
• 14.6 Choosing Database Block Size
• 14.7 Physical Block Structure
• 14.8 Extent-Level Storage Parameters
• Chapter 15: Hardware Resource Usage Tuning
• 15.2 How Oracle Database Uses Memory
• 15.3 Tuning Oracle IO Usage
• Chapter 16: Tuning Network Usage
• 16.1 The Listener
• 16.2 Network Naming Methods
• 16.3 Connection Profiles
• 16.4 Shared Servers
• Chapter 17: Oracle Partitioning and Parallelism
• 17.1 What is Oracle Partitioning?
• 17.2 Tricks with Partitions
• Chapter 18: Ratios: Possible Symptoms of Problems
• 18.1 Database Buffer Cache Hit Ratio
• 18.2 Table Access Ratios
• 18.3 Index Use Ratio
• 18.4 Dictionary Cache Hit Ratio
• 18.5 Library Cache Hit Ratios
• 18.6 Disk Sort Ratio
• 18.7 Chained Rows Ratio
• 18.8 Parse Ratios
• 18.9 Latch Hit Ratio
• Chapter 19: Wait Events
• 19.1 Idle Events
• 19.2 Significant Events
• Chapter 20: Latches
• 20.2 The Most Significant Latches
• Chapter 21: Tools and Utilities
• 21.2 Spotlight
• 21.3 Operating System Tools
• 21.4 Other Utilities and Tools
• Chapter 22: Tuning with the Wait Event Interface and STATSPACK
• 22.1 What is a Bottleneck?
• 22.2 Detecting Potential Bottlenecks
• 22.3 What is the Wait Event Interface?
• 22.4 Oracle Database Wait Event Interface Improvements
• 22.5 Oracle Enterprise Manager and the Wait Event Interface
• 22.6 Using STATSPACK
• Appendix A: Sample Databases
• Active Concurrent Database Scripting
• Updating Summary Fields
• Partitioning Tablespace Creation
• Appendix B: Sample Scripts
• Statistics Generation
• Count Rows
• Constraints
• Indexes
• Space in the Database
• TKPROF Trace Files Interpretation Scripts
• The TKPROF Interpretation Script
• Appendix C: Sources of Information
• Index
• Index_B
• Index_C
• Index_D
• Index_E
• Index_F
• Index_H
• Index_I
• Index_J
• Index_L
• Index_M
• Index_N
• Index_O
• Index_P
• Index_R
• Index_S
• Index_T
• Index_U
• Index_W
• List of Figures