Oracle 11g SQL Performance Tuning
Course
In London
Description
-
Type
Course
-
Location
London
-
Class hours
14h
-
Duration
2 Days
Suitable for: This course introduces the delegate to the main concepts of Oracle SQL performance tuning. It is designed to give delegates practical experience in analyzing and tuning the performance of SQL. This course is suitable for users of Oracle Database 10g and Oracle Database 11g.
Facilities
Location
Start date
Start date
Reviews
Subjects
- SQL
Course programme
To provide the skills needed to monitor and tune an Oracle database application.
Oracle 11g SQL Performance Tuning Training Course
Course Contents - DAY 1
Course Introduction
- Administration and Course Materials
- Course Structure and Agenda
- Delegate and Trainer Introductions
- Tuning Overview
- Oracle Tuning Process
- Planning a Routine Monitoring Regime
- Setting Suitable Goals
- Tips for Avoiding Problematic Queries
- Overview of SQL Statement Tuning
- Tools to Assist in SQL Tuning
- Explain Plan
- Autotrace
- SQL Trace
- The tkprof Program
- Interpreting SQL Trace
- SQL Optimizer
- OPTIMIZER_MODE Initialization Parameter
- Rule Based Optimizer
- Cost Based Optimizer
- The Analyze Command
- Managing Statistics with DBMS_STATS
- Automatic Statistics Gathering
- How Oracle Processes Sorts
- Temporary Disk Space Assignment
- SQL Operations that Use Sorts
- Index Overview
- B*Tree Indexes
- Access Paths with Indexes
- Index Scans
- Conditions That Stop Indexes Being Used
- Parameters Affecting Optimizer Index Choice
- Bitmap Indexes
- Key Compressed Indexes
- Index Organized Tables
- Function Based Indexes
- Descending Indexes
- Invisible Indexes
Course Contents - DAY 2
Session 7: JOINS
- Joining Tables
- Nested Loops Join
- Merge Join
- Cluster Join
- Hash Join
- Anti Join and Semi Join
- Outer Joins
- Star Join
- Sequence Caching
- Views
- View Merging
- Inline Views
- Using Hints to Influence Execution Plan
- Optimization Mode and Goals
- Access Methods
- Query Transformations
- Join Orders
- Join Operations
- Hint Examples
- Syntax Considerations
- Array Size
- hared Pool
- Intelligent Cursor Sharing
- Virtual Columns
- Result Caching
- Some PL/SQL Issues
Oracle 11g SQL Performance Tuning