SETC Training844-434-7382
 Find a Course: 
 
Programming TrainingMicrosoft TrainingMS Office TrainingServer TrainingManagement TrainingNetwork TrainingAbout UsContact Us

Oracle Training


Good location and good computer setup so we can see the instructor s screen at our own desk computer. Front desk staff is very friendly. Nice training environment.
Comment from HRSDC

1. Title

  • Professional Oracle Database Tuning and Optimization (ORATUNING, 5 days)
    View PDF

2. Course Pre-requisites

  • Strong familiarity with PL/SQL

3. Target Audience

  • Database professionals who want a faster Oracle Database

4. Dates and Pricing


Sep 11 to Sep 15, 2017$2,775.00/person
Nov 27 to Dec 1, 2017$2,275.00/person

5. Outline

Module 1: Performance Tuning and Optimization

Topic 1: Learning Objectives

Topic 2: Performance Tuning with Initialization Parameters

Topic 3: Using the Oracle SQL Trace Utility

Topic 4: Stored Outlines

Topic 5: Query Tuning

Topic 6: Objectives Covered

Module 2: Monitoring System Performance

Topic 1: Learning Objectives

Topic 2: Overview of the AWR

Topic 3: Identifying Problems

Topic 4: Baselines

Topic 5: Analyzing AWR Output

Topic 6: Metrics and Alerts

Topic 7: Objectives Covered

Module 3: SQL Statement Structural Optimization

Topic 1: Learning Objectives

Topic 2: Optimizing for Range Queries

Topic 3: Optimizing for Point Queries

Topic 4: Optimizing Sort Operations

Topic 5: Optimizing for Aggregate Calculations

Topic 6: Optimizing for Join Operations

Topic 7: Optimizing Complex SQL Queries

Topic 8: Objectives Covered

Module 4: Enhancing PL/SQL Performance

Topic 1: Learning Objectives

Topic 2: Overview

Topic 3: Log Timing Information

Topic 4: Use ROWID when Performing Iterative Processing

Topic 5: Standardize the PL/SQL Code

Topic 6: Using the Shared Pool and Pinning PL/SQL Objects

Topic 7: Finding Invalid Objects

Topic 8: Finding Disabled Triggers

Topic 9: Using PL/SQL Associative Arrays for Table Lookups

Topic 10: Using Rollback Segments

Topic 11: SQL Performance Analyzer

Topic 12: Objectives Covered

Module 5: Indexing

Topic 1: Learning Objectives

Topic 2: Overview of Index Types

Topic 3: Choosing the Right Index

Topic 4: Creating Indexes

Topic 5: Rebuilding Indexes

Topic 6: Overview of Partition Indexes

Topic 7: Maintaining Partition Indexes

Topic 8: Maximizing Performance with Local and Global Indexes

Topic 9: Monitoring Index Partition Usage

Topic 10: Overview of Unusable Indexes

Topic 11: Rebuilding Unusable Indexes

Topic 12: Objectives Covered

Module 6: Query Optimizer

Topic 1: Learning Objectives

Topic 2: Join Methods

Topic 3: Using Hints to Influence the Optimizer

Topic 4: Bitmap Join Index

Topic 5: Objectives Covered

Module 7: Memory Tuning

Topic 1: Learning Objectives

Topic 2: Automatic Memory Management

Topic 3: Tuning the Shared Pool

Topic 4: Tuning the Buffer Cache

Topic 5: Tuning PGA and Temporary Space

Topic 6: Tuning Segment Space Usage

Topic 7: Tuning I/O

Topic 8: Objectives Covered

Module 8: Database Replay

Topic 1: Learning Objectives

Topic 2: Overview

Topic 3: Workload Capture

Topic 4: Preprocessing a Workload

Topic 5: Replaying a Workload

Topic 6: Analyzing a Replayed Workload

Topic 7: Objectives Covered

Module 9: A Complete Database Tuning and Optimization Lab

SETC Training on LinkedIn follow @CTESTraining Follow us on Facebook
  Programming Training
  Microsoft Training
  Network Training
  Management Training
  Server Training
  Microsoft Office Training
Site developed and authored by Jean-Marc Choquette