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

Oracle Training


I really liked the fact that we could follow using the manual PDF files on our individual machines. This allowed to easily/quickly scroll back/forth the slides without having to interrupt the class to ask to go back to certain slides when needing to review something. This also allowed to easily search within the manual for specific keywords while doing exercises
Comment from Mitel

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