Key Highlights of the Course


✔️ 12 months unlimited access to LIVE classes and Course Recordings

✔️ Training on Latest Version - Oracle Database 19c

✔️ Oracle University Prescribed Course Curriculum

✔️ 100% hands-on training with In-depth and Simplified Lectures

✔️ Downloadable course materials - Course Slides and Lab Guide

✔️ Life-time Access to Private Whatsapp Group of the Course

✔️ Daily Live Interactions with the Course Instructor and Course Community

✔️ Course completion certificate

✔️ Learn at your own pace

✔️ Learn at your own comfort

✔️ Learn the Best, Learn from the Best


Course Topics


  1. Introduction
  2. Defining the Scope of Performance Issues
  3. Basic Tuning Diagnostics
  4. Using Automatic Workload Repository (AWR)
  5. Using Metrics and Alerts
  6. Using Baselines
  7. Using AWR-based Tools
  8. Using Statspack
  9. Real-time Database Operation Monitoring
  10. Monitoring Applications
  11. Tuning the Shared Pool
  12. Tuning the Buffer Cache
  13. Tuning Redo Log
  14. Tuning PGA and Temporary Space
  15. Reducing the Cost of SQL Operations
  16. Using SQL Performance Analyzer
  17. Using Database Replay



Course Videos (Members Area)


  Downloadable Resources
Available in days
days after you enroll
  Lab Setup
Available in days
days after you enroll
  Introduction
Available in days
days after you enroll
  Defining the Scope of Performance Issues
Available in days
days after you enroll
  Basic Tuning Diagnostics
Available in days
days after you enroll
  Using Automatic Workload Repository (AWR)
Available in days
days after you enroll
  Using Baselines
Available in days
days after you enroll
  Using AWR-based Tools
Available in days
days after you enroll
  Using Metrics and Alerts
Available in days
days after you enroll
  Using Statspack
Available in days
days after you enroll
  Real-time Database Operation Monitoring
Available in days
days after you enroll
  Monitoring Applications
Available in days
days after you enroll
  Tuning the Shared Pool
Available in days
days after you enroll
  Tuning the Buffer Cache
Available in days
days after you enroll
  Tuning the Redo Log
Available in days
days after you enroll
  Tuning PGA and Temporary Space
Available in days
days after you enroll
  Using Automatic Memory Management
Available in days
days after you enroll
  Reducing the Cost of SQL Operations
Available in days
days after you enroll
  Using SQL Performance Analyzer
Available in days
days after you enroll
  Using Database Replay
Available in days
days after you enroll

Enroll to get Instant Access to Full Course


Explore our other Courses


Oracle Exadata Database Machine Administration with LAB

1 Year Unlimited Access to Video Course and LIVE Course

Muralidhar Punyala

Muralidhar Punyala

₹30,000

Oracle Database 19c : Managing Multitenant Architecture

Self Paced Learning

Muralidhar Punyala

Muralidhar Punyala

₹15,000

Oracle RAC 19c Administration

1 Year Unlimited Access to Video Course and LIVE Course

1 Course Bundle

₹25,000