Trainer

24 yrs exp

Duration

16 Days Days

Recordings

24 Hrs Hrs

Material

Reading and LAB guide

Online LAB

Server 24x7 available

Course Overview

The Oracle Performance Tuning Training is designed to equip participants with real-world skills for Oracle 12c Performance Tuning. This course provides hands-on experience to boost career opportunities in database performance tuning. 
✅ Course Objectives: 
  • Learn tuning methodology and DBA tuning responsibilities. 
  • Utilize AWR, ADDM, and performance diagnostic tools. 
  • Identify and resolve performance issues using metrics and alerts. 
  • Optimize SQL performance with execution plans and SQL Analyzer. 
  • Tune shared pool, buffer cache, and PGA for better performance. 
  • Implement dynamic memory management for efficient SGA usage. 
  • Reduce storage and SQL costs with index and space management. 
  • Capture workloads and replay with Database Replay for insights. 
  • Maintain consistent performance using automatic SQL tuning. 
  • Experience real-world scenarios with hands-on labs and certification support. 
✅ Real-time case studies | ✅ Practical hands-on labs | ✅ Certification Guidance 
 

Who should go for this training?
The following professionals can go for this course:

  • Administrator
  • Architect
  • Database Administrator

What are the pre-requisites for this Course?

  • Oracle DBA

Course Overview

Course Content

Expand All
  • Course Objectives
  • Course Organization
  • Course Agenda
  • Topics Not Included in the Course
  • Who Tunes 
  • What Does the DBA Tune 
  • How to Tune
  • Tuning Methodology
  • Performance Tuning Diagnostics
  • Performance Tuning Tools
  • Tuning Objectives
  • Top Timed Events
  • DB Time
  • CPU and Wait Time Tuning Dimensions
  • Time Model
  • Dynamic Performance Views
  • Automatic Workload Repository Overview
  • Automatic Workload Repository Data
  • Enterprise Manager Cloud Control and AWR
  • Snapshots
  • Reports
  • Compare Periods
  • Defining the Problem
  • Limiting the Scope
  • Setting the Priority
  • Top SQL Reports
  • Common Tuning Problems
  • Tuning During the Life Cycle
  • ADDM Tuning Session
  • Performance Versus Business Requirements
  • Metrics and Alerts Overview
  • Limitation of Base Statistics
  • Benefits of Metrics
  • Viewing Metric History Information
  • Viewing Histograms
  • Server-Generated Alerts
  • Setting Thresholds
  • Metrics and Alerts Views
  • Comparative Performance Analysis with AWR Baselines
  • Automatic Workload Repository Baselines
  • Moving Window Baseline
  • Baselines in Performance Page Settings
  • Baseline Templates
  • AWR Baseslines
  • Creating AWR Baselines
  • Managing Baselines with PL/SQL
  • Automatic Maintenance Tasks
  • ADDM Performance Monitoring
  • Using Compare Periods ADDM
  • Active Session History
  • New or Enhanced Automatic Workload Repository Views
  • Emergency Monitoring
  • Real-time ADDM
  • Overview
  • Use Cases
  • Defining a Database Operation
  • Scope of a Composite Database Operation
  • Database Operation Concepts
  • Identifying a Database Operation
  • Enabling Monitoring of Database Operations
  • Identifying, Starting, and Completing a Database Operation
  • What is a Service 
  • Service Attributes
  • Service Types
  • Creating Services
  • Managing Services in a Single-Instance Environment
  • Where are Services Used 
  • Using Services with Client Applications
  • Services and Pluggable Databases
  • SQL Statement Processing Phases
  • Role of the Oracle Optimizer
  • Identifying Bad SQL
  • Top SQL Reports
  • SQL Monitoring
  • What is an Execution Plan 
  • Methods for Viewing Execution Plans
  • Uses of Execution Plans
  • Functions of the Query Optimizer
  • Selectivity
  • Cardinality and Cost
  • Changing Optimizer Behavior
  • Optimizer Statistics
  • Extended Statistics
  • Controlling the Behavior of the Optimizer with Parameters
  • Enabling Query Optimizer Features
  • Reducing the Cost
  • Index Maintenance
  • SQL Access Advisor
  • Table Maintenance for Performance
  • Table Reorganization Methods
  • Space Management
  • Extent Management
  • Data Storage
  • Real Application Testing: Overview
  • Real Application Testing: Use Cases
  • SQL Performance Analyzer: Process
  • Capturing the SQL Workload
  • Creating a SQL Performance Analyzer Task
  • SQL Performance Analyzer: Tasks
  • Parameter Change
  • SQL Performance Analyzer Task Page
  • Maintaining SQL Performance
  • Maintaining Optimizer Statistics
  • Automated Maintenance Tasks
  • Statistic Gathering Options
  • Setting Statistic Preferences
  • Restore Statistics
  • Deferred Statistics Publishing
  • Automatic SQL Tuning
  • Using Database Replay
  • The Big Picture
  • System Architecture
  • Capture Considerations
  • Replay Considerations: Preparation
  • Replay Considerations
  • Replay Options
  • Replay Analysis
  • Shared Pool Architecture
  • Shared Pool Operation
  • The Library Cache
  • Latch and Mutex
  • Diagnostic Tools for Tuning the Shared Pool
  • Avoiding Hard Parses
  • Reducing the Cost of Soft Parses
  • Sizing the Shared Pool
  • Oracle Database Architecture: Buffer Cache
  • Buffer Cache: Highlights
  • Database Buffers
  • Buffer Hash Table for Lookups
  • Working Sets
  • Buffer Cache Tuning Goals and Techniques
  • Buffer Cache Performance Symptoms
  • Buffer Cache Performance Solutions
  • SQL Memory Usage
  • Performance Impact
  • Automatic PGA Memory
  • SQL Memory Manager
  • Configuring Automatic PGA Memory
  • Setting PGA_AGGREGATE_TARGET Initially
  • Limiting the size of the Program Global Area (PGA)
  • SQL Memory Usage
  • Oracle Database Architecture
  • Dynamic SGA
  • Granule
  • Memory Advisories
  • Manually Adding Granules to Components
  • Increasing the Size of an SGA Component
  • Automatic Shared Memory Management: Overview
  • SGA Sizing Parameters: Overview
  • Commonly Observed Wait Events
  • Additional Statistics
  • Top 10 Mistakes Found in Customer Systems
  • Symptoms
Brochure Download

Modes of Training

Akswave_classroom

Classroom Training

Lives interactive sessions delivered in our classroom by our expert trainers with real-time scenarios.

Akswave_Online

Online Training

Learn from anywhere over internet, joining the live sessions delivered by our expert trainers.

Akswave_Selfpaced

Self-Pace Training

Learn through pre-recorded video sessions delivered by experts with your own pace and timings

For Coporate Training, We provide customized content and delivered by industry experts with complete practical demonstration, discussions and exercises based on practical use cases.

Contact Us

Our Key Highlights

Unique Benefits included in this training

  • BEST TRAINER : OCM Certified, 22 Yrs exp and delivered more than 350 batches
  • QUALITY CONTENT : Covers in-depth and industry-relevant advance topics.
  • LAB ACCESS : Practice hands-on with dedicated online servers, anytime, anywhere.
  • BEST PRICE : Best value training at a competitive price.
  • SESSION RECORDINGS : Access to session recordings for easy revision.
  • REAL-TIME SCENARIOS : Learn through practical scenarios and live projects.
Key Benefits

Upcoming Batches

CLASSROOM TRAINING

This Course Includes:
  • Delivered by our experts having 22 yrs exp
  • 16 Live classroom sessions
  • Reading material and Lab activity guide
  • One-to-one dedicated server access for practice
  • 35 Hrs of Lab practices
  • 100% practical-oriented classes
  • Real-time projects and certification guidance
  • Get certificate on course completion
  • Job assistance
  • Certified technical assistance
30-Apr

7:00am to 8:30am IST

15 Days (Mon-Fri)

06-May

7:00am to 8:30am IST

15 Days (Mon-Fri)

09-May

7:00am to 8:30am IST

15 Days (Mon-Fri)

Course Fee : ₹ 16,000/-

Discount : ₹ 4,000/- (25%)

Offer Price : ₹12,000/-

ONLINE TRAINING

This Course Includes:
  • Delivered by our experts having 22 yrs exp
  • 16 Virtual online sessions
  • Access for 24 Hrs of Recorded videos
  • Reading material and Lab activity guide
  • 24x7 dedicated online AksWave server access
  • 35 Hrs of Lab practices
  • 100% practical-oriented classes
  • Real-time projects and certification guidance
  • Get certificate on course completion
  • Job assistance
  • Technical support thru chat and email
30-Apr

6:30am to 8:00am IST

15 Days (Mon-Fri)

05-May

6:30am to 8:00am IST

15 Days (Mon-Fri)

08-May

6:30am to 8:00am IST

15 Days (Mon-Fri)

Course Fee : ₹ 28,000/-

Discount : ₹ 6,000/- (21%)

Offer Price : ₹22,000/- $257

SELF-PACED LEARNING

This Course Includes:
  • Access for 24 Hrs of Recorded videos
  • Reading material and Lab activity guide
  • 24x7 dedicate online AksWave server access
  • 35 Hrs of Lab practices
  • Real-time projects and certification guidance
  • Technical support thru chat and email

₹16,000/-

Our Instructor

Akal Singh

Akal Singh

Oracle Certified Master

  • 4.9 Instructor Rating
  • 8,852 Reviews
Akal Singh stands at the forefront of the fastest-evolving technologies in the IT industry. With over 24 years of experience as an Oracle DBA, he has honed expertise in DBA support, high availability design and implementation, technical solutions, automation through scripting, and database design. In addition to his technical skills, Akal Singh has made a significant impact as a corporate trainer.

He holds an impressive array of certifications, including OCP, Oracle Certified Expert/Specialist (OCE), and Oracle Certified Master (OCM). His extensive technical knowledge spans operating system administration, virtualization/VMWare, and multiple Oracle Database versions—from 8i through 23ai. His skills also cover Hardware, OS Administration, DBA, Oracle Apps, RAC, Data Guard, ASM, Oracle Exadata, performance tuning, Golden Gate, Streams, and advanced security measures.

Recognized as a Senior Corporate Instructor, Akal Singh has also served with Oracle University, delivering over 300 corporate trainings on advanced database concepts. His deep industry insights and real-time project implementations continue to influence the IT and database community significantly.

Certifications include :
  • Oracle Certified Professional (OCP) 9i, 10g, 11g and 12c
  • Oracle Certified RAC Expert (OCE)
  • Oracle RAC 11g Release 2 and Grid Infrastructure Administration
  • Oracle Database 12c: RAC and Grid Infrastructure Administrator
  • Oracle 11g Exadata Certified Implementation Specialist
  • Oracle Exadata X5 Administration
  • Oracle Database 12c: RAC and Grid Infrastructure Administrator
  • Oracle 10g Certified Master (OCM)
  • Oracle Cloud Autonomous Database Specialist
  • Oracle Cloud Infrastructure Certified Associate
  • Foundation Certificate in IT Service Management (ITIL Certificate)

Demo Video

No Video Found

No Demo Video

Certification Guidence

  • This course is specifically designed to help you successfully clear the Oracle Database Performance Management and Tuning certification exam. Our comprehensive course content, combined with guidance from expert trainers, ensures that you gain the skills and knowledge needed to confidently pass the certification.

    Certification Details:
    Throughout the course, we cover key topics essential for the certification exam, providing hands-on expertise and real-world insights.

    ✅ Upon Course completion: You will receive the Akswave Course Completion Certificate, validating your achievement and readiness for industry opportunities.
AksWave Certificate

Faq

Our trainer is an OCP & OCM certified consultant and has significant amount of experience in working with the technology, having 18yrs of experience.


Once you get registered, our back-end team will share you the details to join the session live over online portal which can be accessed through a browser.

Each of our live sessions are recorded. In case if you miss any, you can request us to share the link of that 

particular session.

For practical execution, our trainer/technical team will provide server access details to the student


Yes. We do provide the step-by-step document which you can follow and if required our technical team will assist you.

Live-Online training is where you can have live session with the trainer and clarify queries parallely.

Pre-recorded sessions are the recorded videos that will be provided to you that you can see, listen and learn anytime at ur feasible place. For doubts in the videos you can mail the trainer regarding the same.

You can contact our support team, or just drop an email to online@akswave-trainings.com with your queries.

The course material and recorded videos which are provided during the course period. You can download it anytime.

Visit our website regularly to check discount offers time to time. However, we provide discount for single participant

& special discount for 2 or more participants.

* If request for cancelation is made within 2 days of enrolment for class, 100% refunded.

* If request made after 2 days, then Refund is made after deduction of administration fee.

Combo Offers

Pay less and learn more with our best combo courses. Avail more discount on multiple top trending technologies

Oracle 12C DBA

Enroll Now

Classroom

Oracle 12C DBA +
RAC Administration
(548 Reviews)

 22,000/-

save 8%

 24000/-
RAC Administration

Enroll Now

Classroom

RAC Administration +
12c Goldengate
(312 Reviews)

 21,000/-

save 13%

 24000/-
RAC Administration

Enroll Now

Online

RAC Administration +
Exadata X8M & X10M
(130 Reviews)

 40,000/-

save 26%

 54000/-
Oracle 12C DBA

Enroll Now

Classroom

Oracle 12C DBA +
Apps DBA 12.2
(311 Reviews)

 20,000/-

save 29%

 28000/-

Related Courses

View All Courses

Testimonials

Manoj Kumar
3 years ago

I recently took Oracle RAC training from Akswave. Akal Sir is one of the best teacher for Oracle RAC. I learned lot of concepts, understood well and he cleared many of my doubts too. His explanation and presentation is better and easy to understand. About online Lab environment its good and the Co-ordinators are very helpful in clearing my doubts. I personally enjoyed and learned many new things in AKSWAVE.

Ravi Krishna
3 years ago

I have taken classes from Akswave Oracle Training and I gained excellent knowledge in Oracle DBA , Oracle RAC and APPs from there. I recommend people who wants better future in Oracle DBA, join Akswave. Lets see when the GoldenGate classroom training will start, I like to join.

Azjad Hussain
4 years ago

Akswave Oracle Training is one of the best institute in Ameerpet, comparing to other institutes in terms of Lab Infrastructure , helping nature faculties and the amazing skilled Mr Akal singh. Now waiting for cloud training to be started.

Google Ratings

4.6

Facebook Ratings

4.9

Twitter Ratings

4.8