LIVE - PT

Oracle Database Performance Tuning

Live Online Training

Interactive learning
Attend daily live online classes
Live doubt clarification

About the Course

Oracle Database Performance Tuning course teaches you how to use various Oracle Database Performance Features and Tools to identify, investigate and troubleshoot Oracle Database Performance problems. Three areas of primary focus for tuning - SQL Tuning, Instance Tuning and Database Tuning are covered. You will also learn how to maintain SQL and Database Performance against changes to the database environment. This is a 100% hands-on course.

Training Details

Instructor-led Live Online Training
Duration: 6 weeks
Daily Live Class: 60 - 90 minutes (Monday - Friday, IST)
1 Year Unlimited Access to Course Recordings
Downloadable Course Materials - Slides , Lab Guide
Live Doubts Clarifications
Free Membership in Course Community
Course Completion Certificate

Pay and Enroll

Course Curriculum

Module1: Basic Tuning Tools
Introduction to the course
Performance Tuning General Concepts
Basic Tuning Tools - Statistics and Wait Events
Using AWR
Using Metrics and Alerts
Using Baselines
Using AWR Based Tools - ADDM, ASH
Using Statspack
Module 2: SQL Tuning
SQL Performance Fundamentals
Query Optimizer Fundamentals
Query Execution Plans
SQL Operators: Access Paths & Joins
Optimizer Statistics
Optimizer Controls
Monitoring and Tracing SQL
Module3: Instance Tuning
Tuning the Shared Pool
Tuning the Buffer Cache
Tuning Redo Log
Tuning PGA and Temporary Space
Index Maintenance for Performance
Table Maintenance for Performance
Module4: Performance Management
SQL Performance Management
Using SQL Performance Analyzer
Using Database Replay

What you will Learn?

• Use the Oracle tuning methodology
• Use Oracle-supplied tools for monitoring and diagnosing SQL and instance tuning issues
• Use database advisors to proactively correct performance problems
• Identify problem SQL statements
• Tune SQL performance problems
• Monitor instance performance by using Enterprise Manager
• Tune instance components by primarily using instance parameters

Key Highlights

Free Download - Pre-built VM Images for Lab Practices
High Quality and High Impact Training
High Quality and Up-to-date learning content
HD Quality Audio & Video Visuals
In-depth explanation of each lesson
Simple and Easy to understand explanation of each lesson
Hands-on demonstrations
1 Year 24/7 access to course videos
Downloadable Course Materials - Slides, Lab Guide
Free Membership in Course Community
Course Completion Certificate

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.

Stay Updated !

Signup to receive training updates and discount offers.