10g Performance Tuning

Introduction
Cause of Performance Problems
Setting Performance Goals
The Tuning Cycle
ORACLE Architecture
Logical Storage Structures
Physical Structures
Memory Structures
The Shared Pool
Processes
Some Administration Terminology

Design
Data Design Phase
Data Model Design
Online Transaction Processing
Decision Support Systems
Multi-purpose Applications

Optimizing SQL
SQL Processing
Physical Retrieval of Data
Full Table Scan versus Index Reads
Performance Diagnostic Tools
Explain Plan
SQL Trace Facility
TKPROF
Autotrace
Join Methods
Sort/Merge Joins
Nested Loops
Hash Joins
Hash Join Example Data Access Methods
Basic Indexes
B-Tree Indexes
Bitmap Index
Creating and maintaining Bitmap Indexes.
Comparing B-Tree and Bitmap Indexes
Reverse Key Index
Creating Reverse Key Indexes
Index-Organised Tables
Creating Index-organised Tables
Clusters
Cluster Types

Automatic SQL Tuning
Query Optimizer Modes
Types of Tuning Analysis
SQL Tuning Advisor
SQL Tuning Sets
Top SQL
Identify high-load SQL
ADDM
Dynamic Performance views
Statspack

The Optimizer
Optimizing SQL
The ORACLE Optimizer
Initialisation parameters affecting the Optimizer.
Cost Based
Rule / Cost Comparisons
Choosing an Approach
Rule Based Approach
Multiple WHERE Clauses
Using Indexes without a WHERE clause
Using Indexes for Sorts
Multiple Table Joins
Disabling Indexes
Use of NOT IN / NOT EXISTS
Cost Based Optimizer
Cost Based Optimizer Operation
Hints.
Sharing SQL Statements
Other SQL Tuning Tips

Gathering Statistics
Analyzing Statistics
DBMS_STATS
Histograms
How to Generate Histograms Statistics
Migration from Rule to Cost based Optimization Plan stability:-Stored Outlines.

Optimising PL/SQL
Module Performance
Registering a Module
Tracking a Module

Advanced Tuning
Star Queries
Materialized Views
Refreshing Views
Materialized View Logs
Temporary Tables