Introduction to the 9i Optimizer
Gives you an Overview of SQL Processing, Optimizer, Choosing an Optimizer Approach and Goal, Cost-Based Optimizer, Access Paths for the CBO, Joins, Setting Cost-Based Optimizer Parameters, and Extensible Optimizer

How the Optimizer Performs Operations

Gathering Optimizer Statistics
Understanding Statistics, Generating Statistics, Using Statistics and Histograms

Understanding Indexes and Clusters
Covers Understanding Indexes, Function-based Indexes, Index-Organized Tables, Bitmap Indexes, Bitmap Join Indexes, Domain Indexes, Clusters, Hash Clusters

Optimizer Hints
Optimizer hints can be used with SQL statements to alter execution plans. This chapter explains how to use hints to force various approaches

Optimizing SQL Statements
This chapter describes how to identify high-resource SQL statements, explains what should be collected, and provides tuning suggestions.

Using Plan Stability
This chapter describes how to use plan stability to preserve performance characteristics

Using the Rule-Based Optimizer
This chapter discusses Oracle's rule-based optimizer (RBO). In general, always use the cost-based approach. The rule-based approach is available for backward compatibility

Using EXPLAIN PLAN
This chapter introduces execution plans, describes the SQL command EXPLAIN PLAN, and explains how to interpret its output.

Using SQL Trace and TKPROF
The SQL Trace facility and TKPROF are two basic performance diagnostic tools that can help you monitor and tune applications running against the Oracle Server

Using Autotrace in SQL*Plus
This chapter provides information on using the Autotrace feature in SQL*Plus and the iSQL*Plus statistics report

Using Oracle Trace
This chapter describes how to use Oracle Trace to collect Oracle server event data

Building a Database for Performance
Although performance modifications can be made to both the database and to the Oracle instance at a later time, much can be gained by carefully designing the database for the intended needs

Memory Configuration and Use
Proper sizing and effective use of the Oracle memory caches greatly improves database performance. This chapter explains how to allocate memory to Oracle memory caches, and how to use those caches

I/O Configuration and Design
The I/O subsystem is a vital component of an Oracle database. This chapter introduces fundamental I/O concepts, discusses the I/O requirementsof different parts of the database, and provides sample configurations for I/O subsystem design

Understanding Operating System Resources
This chapter explains how to tune the operating system for optimal performance of the Oracle database server

Configuring Instance Recovery Performance
This chapter offers guidelines for configuring the time to perform instance recovery

Configuring Undo and Temporary Segments
There are performance considerations when configuring undo and temporary segments

Configuring Shared Servers
Proper configuration of shared servers can result in significant performance improvement

Oracle Tools to Gather Database Statistics
This chapter explains why performance data gathering is important, and it describes how to use available Oracle tools.

Using Statspack
This chapter explains how to install, configure, and use Statspack

Instance Tuning
After the initial configuration of a database, tuning an instance is important to eliminate any performance bottlenecks

Tuning Networks
This chapter describes different connection models and introduces networking issues that affect tuning.

Dynamic Performance Views for Tuning
This chapter provides detailed information on some of the dynamic views that can help you tune your system and investigate performance problems

Designing and Developing for Performance
This chapter provides detailed information on some of the dynamic views that can help you tune your system and investigate performance problems

Designing and Developing for Performance
Good system performance begins with design and continues throughout the life of your system. Carefully consider performance issues during the initial design phase, and it will be easier to tune your system during production

Monitoring and Improving Application Performance
Covers Importance of Statistics and the Oracle Performance Improvement Method

Performance and Tuning Articles

Performance and Tuning FAQ

Performance and Tuning Scripts

HOME