Oracle High Performance Tuning for 9i and 10g
Oracle High Performance Tuning for 9i and 10g
ISBN: 1555583059
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 164
Pages: 164
Authors: Gavin JT Powell
- 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
Oracle High Performance Tuning for 9i and 10g
ISBN: 1555583059
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 164
Pages: 164
Authors: Gavin JT Powell