INTRODUCTION TO ORACLE PERFORMANCE TUNING

•    Tuning Overview
•    Oracle Tuning Process
•    Setting Suitable Goals
•    Tips for Avoiding Problematic Queries
•    Syntax Considerations
•    Programming Standards
•    Isolate a Performance Problem
•    Analyze a Problem SQL Statement to Determine the Nature of the Problem

TOOLS FOR EVALUATING SQL STATEMENTS

•    Overview of SQL Statement Tuning
•    Tools to Assist in SQL Tuning
•    Use Explain Plan, Autotrace and SQL Trace to Examine the Execution of a SQL Statement
•    Interpreting a SQL Trace

OPTIMIZER STATISTICS

•    Cost-Based Optimizer
•    Analyze and Use System Statistics
•    Managing Statistics with DBMS_STATS
•    Automatic Statistics Gathering
SORTS

•    How Oracle Processes Sorts
•    Temporary Disk Space Assignment
•    SQL Operations that Use Sorts

INDEXES

•    Index Overview
•    B*Tree Indexes
•    Access Paths with Indexes
•    Index Scans
•    Conditions That Stop Indexes Being Used

ADVANCED INDEXES

•    Bitmap Indexes
•    Key Compressed Indexes
•    Index Organized Tables
•    Function Based Indexes
•    Descending Indexes
•    Invisible Indexes

JOIN OPERATIONS

•    Understand Access Paths
•    Joining Tables
•    Nested Loops Join
•    Merge Join
•    Cluster Join
•    Hash Join
•    Anti Join and Semi Join
•    Outer Joins
•    Star Join
•    Improve Optimization with Different Access Paths

SQL TUNING ADVISOR

•    The DBMS_SQL_TUNE Package
•    Using the SQL Tuning Advisor with SQL Developer

SQL PLAN MANAGEMENT

•    Use SQL Plan Management
•    Adaptive SQL Plan Management
•    Adaptive Query Optimization

SEQUENCES AND VIEWS

•    Sequence Caching
•    Views
•    View Merging
•    Inline Views

USING HINTS

•    Using Hints to Influence Execution Plan
•    Optimization Mode and Goals
•    Access Methods
•    Query Transformations
•    Join Orders
•    Join Operations
•    Hint Examples

MISCELLANEOUS

•    Array Size
•    Bind Variable Usage
•    Adaptive Cursor Sharing
•    Result Caching