Home
Customize
Help
Contact Us
Table of Contents for Oracle8
i
Designing and Tuning for Performance
Contents
Title Page
Index
Managing Shared SQL and PL/SQL Areas
Comparing SQL Statements and PL/SQL Blocks
Keeping Shared SQL and PL/SQL in the Shared Pool
Overview of Diagnostic Tools
Sources of Data for Tuning
Dynamic Performance Views
Oracle and SNMP Support
EXPLAIN PLAN
SQL Trace and TKPROF
Supported Scripts
Application Registration
Oracle Enterprise Manager, Packs, and Applications
Oracle Parallel Server Management
Independent Tools
Using EXPLAIN PLAN
Understanding EXPLAIN PLAN
Creating the Output Table
Displaying PLAN_TABLE Output
Output Table Columns
Bitmap Indexes and EXPLAIN PLAN
EXPLAIN PLAN and Partitioned Objects
EXPLAIN PLAN Restrictions
Using SQL Trace and TKPROF
Understanding SQL Trace and TKPROF
Using the SQL Trace Facility and TKPROF
Avoiding Pitfalls in TKPROF Interpretation
TKPROF Output Example
Using Oracle Trace
Introduction to Oracle Trace
Using Oracle Trace Manager
Using Oracle Trace Data Viewer
Manually Collecting Oracle Trace Data
Dynamic Performance Views
Instance-Level Views for Tuning
Session-Level or Transient Views for Tuning
Current Statistic Values and Rates of Change
Diagnosing System Performance Problems
Tuning Factors for Well Designed Existing Systems
Insufficient CPU
Insufficient Memory
I/O Constraints
Network Constraints
Software Constraints
Tuning CPU Resources
Understanding CPU Problems
Detecting and Solving CPU Problems
Solving CPU Problems by Changing System Architectures
Tuning Memory Allocation
Understanding Memory Allocation Issues
Detecting Memory Allocation Problems
Solving Memory Allocation Problems
Understanding Oracle Performance Tuning
What Is Performance Tuning?
Who Tunes?
Setting Performance Targets
Setting User Expectations
Evaluating Performance
Tuning I/O
Understanding I/O Problems
Detecting I/O Problems
Solving I/O Problems
Tuning Resource Contention
Understanding Contention Issues
Detecting Contention Problems
Solving Contention Problems
Tuning Networks
Understanding Connection Models
Detecting Network Problems
Solving Network Problems
Tuning the Operating System
Understanding Operating System Performance Issues
Detecting Operating System Problems
Solving Operating System Problems
Performance Tuning Methods
When Is Tuning Most Effective?
Prioritized Tuning Steps
Applying the Tuning Method
Application and System Performance Characteristics
Types of Applications
Registering Applications
Oracle Configurations
Data Access Methods
Using Indexes
Using Function-based Indexes
Using Bitmap Indexes
Using Domain Indexes
Using Clusters
Using Hash Clusters
Transaction Modes
Using Discrete Transactions
Using Serializable Transactions
Tuning Instance Recovery Performance
Understanding Instance Recovery
Tuning the Duration of Instance and Crash Recovery
Monitoring Instance Recovery
Tuning the Phases of Instance Recovery
Using Optimizer Hints
Understanding Hints
Using Hints
The Optimizer
SQL Processing Architecture
EXPLAIN PLAN
What Is The Optimizer?
Choosing an Optimizer Approach and Goal
Cost-Based Optimizer (CBO)
CBO Parameters
Extensible Optimizer
Rule-Based Optimizer (RBO)
Overview of Optimizer Operations
Optimizing Joins
Optimizing Statements that Use Common Subexpressions
Evaluation of Expressions and Conditions
Transforming and Optimizing Statements
Using Plan Stability
Using Plan Stability to Preserve Execution Plans
Plan Stability Procedures for the Cost-Based Optimizer
Introduction to Tuning
Application Design Tuning for Designers and Developers
Application Design Tools for Designers and DBAs
Optimizing Instance Performance
Preface
Send Us Your Comments
Optimizing SQL Statements
Approaches to SQL Statement Tuning
Tuning Goals
Best Practices
SQL Tuning Tips
Using EXISTS versus IN
Trouble Shooting
Tuning Distributed Queries
Gathering Statistics
Understanding Statistics
Generating Statistics
Using Statistics
Using Histograms
Index
Contents
Copyright © 2024, Oracle and/or its affiliates. All rights reserved.