Professional Oracle Database Tuning and Optimization
(ORATUNING, Live Instructor-Led Training, 5 days)


Description

This intensive SETC certified course provides a comprehensive and detailed exploration of Oracle database performance tuning and optimization. Starting with the basic tools of the trade, the course quickly accelerates to coverage of structural SQL optimization techniques and PL/SQL optimization. This is followed by modules covering the concepts of indexing as well as server and memory optimization techniques. And no course on Oracle tuning would be complete in the absence of a comprehensive performance tuning lab. So we do that too. Fine tune your Oracle database with this exceptionally effective SETC certified course.

Dates and Pricing


Nov 27 to Dec 1, 2017$2,275/person Jan 29 to Feb 2, 2018$2,500/person Feb 26 to Mar 2, 2018$2,500/person Mar 26 to Mar 30, 2018$2,500/person

Outline

Performance Tuning and Optimization
Learning Objectives
Performance Tuning with Initialization Parameters
Using the Oracle SQL Trace Utility
Stored Outlines
Query Tuning
Objectives Covered
Monitoring System Performance
Learning Objectives
Overview of the AWR
Identifying Problems
Baselines
Analyzing AWR Output
Metrics and Alerts
Objectives Covered
SQL Statement Structural Optimization
Learning Objectives
Optimizing for Range Queries
Optimizing for Point Queries
Optimizing Sort Operations
Optimizing for Aggregate Calculations
Optimizing for Join Operations
Optimizing Complex SQL Queries
Objectives Covered
Enhancing PL/SQL Performance
Learning Objectives
Overview
Log Timing Information
Use ROWID when Performing Iterative Processing
Standardize the PL/SQL Code
Using the Shared Pool and Pinning PL/SQL Objects
Finding Invalid Objects
Finding Disabled Triggers
Using PL/SQL Associative Arrays for Table Lookups
Using Rollback Segments
SQL Performance Analyzer
Objectives Covered
Indexing
Learning Objectives
Overview of Index Types
Choosing the Right Index
Creating Indexes
Rebuilding Indexes
Overview of Partition Indexes
Maintaining Partition Indexes
Maximizing Performance with Local and Global Indexes
Monitoring Index Partition Usage
Overview of Unusable Indexes
Rebuilding Unusable Indexes
Objectives Covered
Query Optimizer
Learning Objectives
Join Methods
Using Hints to Influence the Optimizer
Bitmap Join Index
Objectives Covered
Memory Tuning
Learning Objectives
Automatic Memory Management
Tuning the Shared Pool
Tuning the Buffer Cache
Tuning PGA and Temporary Space
Tuning Segment Space Usage
Tuning I/O
Objectives Covered
Database Replay
Learning Objectives
Overview
Workload Capture
Preprocessing a Workload
Replaying a Workload
Analyzing a Replayed Workload
Objectives Covered
A Complete Database Tuning and Optimization Lab