Login

Oracle Database Performance Tuning

Self-Paced Course

  • Learn at your own pace and free time

  • Your Course, Your Time, Your Comfort

  • 1 Year 24/7 access

  • 130+ Video Lessons

  • Slides, Lab Guide

  • Support for Doubts

  • Less cost compared to Live Training

  • Recommended for busy/working professionals

Buy now (₹20,000, $285)

The only Course you would ever require on Performance Tuning

How it Works?

  1. Enroll in the course and get your access

  2. Start learning at your own pace and free time, using step-by-step video tutorials

  3. Clarify doubts - via WhatsApp/Email/Phone Call

  4. Complete the course and download course completion certificate

  5. Open the doors for world of new opportunities

Why Learn Performance Tuning Skills?

✔️Go beyond the "normal" and "routine" DBA chores.

✔️Learn to perform the "REAL" DBA work

✔️Get better understanding of Oracle Database and its Internals

✔️Stay "tall" and "above" the rest in your team

✔️Become Subject Matter Expert (SME) and feel Confident

✔️Become an "indispensable" resource to your project and employer

✔️"Recession-proof" your career with "evergreen" and "always in-demand" skills

✔️"Demand" better pay and "command" your team

Course Curriculum

Part 1: Diagnosing and Tuning Database Performance

  • Performance Tuning General Concepts

  • Database Statistics

  • System and Session Statistics

  • Time Model Statistics

  • Wait Event Statistics

  • Automatic Workload Repository (AWR)

  • AWR Architecture

  • AWR Snapshots

  • AWR Reports

  • Managing AWR

  • Reading AWR Reports

  • ADDM

  • Real Time ADDM

  • Active Session History (ASM)

  • ASH Reports

  • Statspack

  • Automated Maintenance Tasks

  • Database Advisors and Health Checkers

    Part 2: SQL Tuning

  • SQL Performance Fundamentals

  • SQL Processing

  • Query Optimizer Fundamentals

  • Query Execution Plans

  • Generating and Reading Execution Plans

  • Access Paths - Table and Index Access Paths

  • Joins - Nested Loop Join, Hash Join, Sort-Merge Join

  • Optimizer Hints

  • Optimizer Statistics

  • Gathering Optimizer Statistics

  • Pending Statistics, Publishing Statistics

  • Deleting Statistics, Restoring Statistics

  • Exporting and Importing Statistics

  • Histograms

  • Column Groups

  • Expression Statistics

  • Real Time SQL Monitoring

  • Monitoring Database Operations

  • Tracing SQLs

  • SQL Trace and TKProf

  • SQL Tuning Sets

  • SQL Tuning Advisor

  • SQL Access Advisor

  • SQL Profiles

  • SQL Plan Management

  • SQL Performance Analyzer

    Part 3: Tuning Database Memory

  • Tuning the Shared Pool

  • Tuning the Buffer Cache

  • Tuning Redo Log

  • Tuning PGA and Temporary Space

Key Highlights

  • The most comprehensive, high quality and up-to-date learning content

  • 100% Hands-on training with In-depth explanation and demonstration

  • 1 Year unlimited access to Live Class Recordings

  • Downloadable Course Materials - Slides, Lab Guide

  • Clarify doubts - via. email/whatsapp/phone call

  • Course Completion Certificate

  • The only course you would ever require on performance tuning

Course Instructor

Muralidhar Punyala (Murali), is the course instructor for this course and also the founder of Uclid IT School.

Murali is a certified IT Professional with 27 years of Global IT experience on Oracle Database and Cloud Technologies. Murali's core skills include - Oracle DBA, Oracle RAC, Performance Tuning, Oracle Exadata, Oracle Cloud and AWS Cloud. Throughout his career Murali worked with various global IT companies in India, USA, UK, Singapore and Hong Kong. Murali also worked with Oracle India as a Practice Manager.

Course Videos

Buy now (₹20000, $285)

Course Materials

Slides
Lab Guide

Lab Setup

Links to download VM Images, Scripts, Swingbench
Lab Setup-Part1
Lab Setup-Part2

PART 1: Diagnosing and Tuning Database Performance

About this module

What you will learn?

Performance Tuning General Concepts

Performance Tuning General Concepts

Database Statistics

Measuring the Performance of the Database
Preview
Lab - Measuring the Performance of the Database

Automatic Workload Repository (AWR)

Overview of AWR
Preview
Administering AWR
Preview
Lab - Administering AWR - Part 1
Lab - Administering AWR - Part 2
About AWR Report
Lab - Generating AWR Report - Part1
Lab - Generating AWR Report - Part 2
About Baselines
About Baseline Templates
Overview of managing Baselines and Baseline Templates
Lab Practice: Managing Baselines and Baseline Templates
Lab Practice: Managing Baselines and Baseline Templates using OEM CC
About AWR Compare Periods Report
Lab Practice: AWR Compare Periods Report

ADDM

About ADDM
About Real Time ADDM
Lab Practices: ADDM
Lab Practices: ADDM using OEM
Lab Practice: Real Time ADDM in OEM

ASH

About ASH
Lab Practice: Using ASH in OEM
Lab Practice: Querying ASH Views
Lab Practice: Troubleshooting Performance issue using ASH Report

Statspack

About Statspack
Lab Practices: Using Statspack

Automated Maintenance Tasks

About Automated Maintenance Tasks
Overview of Configuring Automated Maintenance Tasks
Lab Practice: Configuring Automated Maintenance Tasks

Oracle Database Advisors and Health Checkers

About Oracle Database Advisors
About Health Checkers
Lab Practices: Advisors and Checkers

PART 2 : SQL Tuning

What you will learn?

SQL Tuning Fundamentals

SQL Tuning Fundamentals
Processing of SQL Statements

Query Optimizer Fundamentals

Optimizer Fundamentals

Query Execution Plans

What is Execution Plan?
How to display Execution Plans?
Using AUTOTRACE to display Execution Plan
Using EXPLAIN PLAN and DBMS_XPLAN to display Execution Plan
How to Read Execution Plans?
Lab Practices

Access Paths and Join Methods

Overview of Access Paths
Overview of Join Methods
Overview of Join Order
Lab Practices - Access Paths
Lab Practices: Join Methods

Optimizer Hints

Overview of Hints
Lab Practices: Using Hints

Optimizer Statistics

Overview of Optimizer Statistics
Types of Optimizer Statistics
How Database Gathers Statistics?
Manually Gathering Optimizer Statistics
Lab Practice: Optimizer Statistics Concepts
Lab Practice: Gathering Optimizer Statistics
Lab Practice: Histograms
Lab Practice: Column Group Statistics
Lab Practice: Expression Statistics
Configuring Options for Optimizer Statistics Gathering
Lab Practice: Configuring Options for Optimizer Statistics Gathering
Managing Optimizer Statistics
Lab Practices: Locking and Unlocking Statistics, Publishing Pending Statistics, Using Artificial Statistics
Lab Practice: Exporting and Importing Optimizer Statistics
Lab Practice: Managing Historical Optimizer Statistics

Monitoring Database Operations

Monitoring Database Operations
Lab Practices: Monitoring Database Operations

End-to-End Application Tracing

What is End-to-End Application Tracing?
Tools for Tracing
SQL Trace
TRCESESS
TKPROF
Lab Practices: End-to-End Application Tracing

SQL Tuning Set (STS)

Overview of SQL Tuning Set
Lab Practice: SQL Tuning Set

SQL Tuning Advisor

Overview of SQL Tuning Advisor
Managing Automatic SQL Tuning Task
Running SQL Tuning Advisor On Demand
Lab Practices: SQL Tuning Advisor

SQL Access Advisor

Overview of SQL Access Advisor
SQL Access Advisor - Basic Tasks
SQL Access Advisor - Quick Tune
SQL Access Advisor - Advanced Tasks
Lab Practices: SQL Access Advisor

SQL Profiles

Overview of SQL Profiles

SQL Plan Management

Overview of SQL Plan Management
Basic Tasks in SPM
Lab Practices: Managing SPM

SQL Performance Analyzer

Overview of SQL Performance Analyzer
Lab Practices: Using SPA

PART 3: Tuning Database Memory

What you will learn?

Tuning Shared Pool

Overview of Shared Pool
Memory Allocation in Shared Pool
Private and Shared SQL Areas
Latches and Mutexes
Shared Pool Common Performance Issues and Indicators
Tuning the Shared Pool
Lab Practices: Tuning Shared Pool

Tuning Database Buffer Cache

Basics of Buffer Cache
Symptoms of Buffer Cache Issues
Solutions for Buffer Cache Issues
Lab Practices: Configuring KEEP POOL

Tuning Redo Log

Overview of Tuning Redo Log
Lab Practices: Tuning the Redo Log

Tuning the PGA and Temporary Space

Overview of Tuning PGA and Temporary Tablespace
Automatic and Manual PGA Management
Statistics, Wait Events and DD View related to PGA
Diagnosing PGA Performance Issues
Tuning Temporary Tablespace
Lab Practices: Tuning the PGA

Buy now

130+ Video Lessons

1 Year 24/7 access

Learn at your own pace

Your Course, Your Time, Your Comfort

Support for Doubt Clarification

Recommended for busy/working professionals

Buy now (₹20000, $285)

The only Course you would ever require on Performance Tuning