Oracle Applications and Database Performance Tuning

The course is method-led. Before any tool is introduced, delegates learn the tuning lifecycle and the time model: where is the database spending time, and is that time even the bottleneck? Most wasted tuning effort comes from optimising something that was never the constraint.

Every module works against a deliberately degraded lab database. Delegates are given a symptom rather than a cause — a slow batch window, a report that regressed after a statistics gather, an application timing out under concurrency — and must find it using AWR, ASH and execution plans before they are permitted to change anything.

Because the exam has sixteen topic areas and no published weightings, coverage is deliberately even. Real Application Testing and Database In-Memory receive proper modules rather than a passing mention, since a skipped topic is a genuine risk against the pass threshold.

Self-paced course

₹15,000

or start with ₹5,000 and pay the balance within 3 months

Pay in full ₹15,000

○ Lessons, videos and quizzes from ₹5,000
🔒 Lab recordings at ₹15,000
🔒 Certification exam at full payment
○ Optional real lab: ₹5,000 per month (after full payment)

Valid 12 months from your first payment. Refund policy

Responsible	XertApp
Last Update	10/28/2026
Completion Time	16 hours 8 minutes
Members	1

Career Courses Oracle Courses Database

Module 1 — Tuning methodology (empty)

12Lessons · 1 hr 36 min
- 1.1 Video: The tuning lifecycle and where to start
  
  New
- 1.1 The tuning lifecycle and where to start
  
  New
- 1.2 Video: The time model: DB time and DB CPU
  
  New
- 1.2 The time model: DB time and DB CPU
  
  New
- 1.3 Video: Wait event classes
  
  New
- 1.3 Wait event classes
  
  New
- 1.4 Video: Response time analysis
  
  New
- 1.4 Response time analysis
  
  New
- 1.5 Video: Dynamic performance views
  
  New
- 1.5 Dynamic performance views
  
  New
- 1.L Lab: Measuring load with the time model and wait classes
  
  Lab New
- Module 1 Quiz: Tuning Methodology
  
  New 10 xp
Module 2 — Automatic monitoring infrastructure (empty)

12Lessons · 1 hr 34 min
- 2.1 Video: Metrics, thresholds and server-generated alerts
  
  New
- 2.1 Metrics, thresholds and server-generated alerts
  
  New
- 2.2 Video: AWR snapshots, retention and configuration
  
  New
- 2.2 AWR snapshots, retention and configuration
  
  New
- 2.3 Video: AWR baselines
  
  New
- 2.3 AWR baselines
  
  New
- 2.4 Video: Distinguishing normal from degraded performance
  
  New
- 2.4 Distinguishing normal from degraded performance
  
  New
- 2.5 Video: Automated maintenance tasks
  
  New
- 2.5 Automated maintenance tasks
  
  New
- 2.L Lab: Configuring AWR and creating baselines
  
  Lab New
- Module 2 Quiz: Automatic Monitoring
  
  New 10 xp
Module 3 — AWR-based diagnostic tools (empty)

12Lessons · 1 hr 34 min
- 3.1 Video: Reading an AWR report
  
  New
- 3.1 Reading an AWR report
  
  New
- 3.2 Video: ADDM findings and recommendations
  
  New
- 3.2 ADDM findings and recommendations
  
  New
- 3.3 Video: ASH reports and recent activity
  
  New
- 3.3 ASH reports and recent activity
  
  New
- 3.4 Video: ASH sampling and its limits
  
  New
- 3.4 ASH sampling and its limits
  
  New
- 3.5 Video: A diagnostic workflow
  
  New
- 3.5 A diagnostic workflow
  
  New
- 3.L Lab: Diagnosing a spike with ASH and ADDM
  
  Lab New
- Module 3 Quiz: AWR Diagnostic Tools
  
  New 10 xp
Module 4 — Identifying problem SQL (empty)

12Lessons · 1 hr 32 min
- 4.1 Video: Finding high-load statements
  
  New
- 4.1 Finding high-load statements
  
  New
- 4.2 Video: SQL trace, TKPROF and event 10046
  
  New
- 4.2 SQL trace, TKPROF and event 10046
  
  New
- 4.3 Video: Real-Time SQL Monitoring
  
  New
- 4.3 Real-Time SQL Monitoring
  
  New
- 4.4 Video: SQL Performance Analyzer
  
  New
- 4.4 SQL Performance Analyzer
  
  New
- 4.5 Video: Plans in the cursor cache
  
  New
- 4.5 Plans in the cursor cache
  
  New
- 4.L Lab: Tracing and monitoring a slow statement
  
  Lab New
- Module 4 Quiz: Identifying Problem SQL
  
  New 10 xp
Module 5 — Execution plans (empty)

12Lessons · 1 hr 32 min
- 5.1 Video: Reading execution plans
  
  New
- 5.1 Reading execution plans
  
  New
- 5.2 Video: Access paths, join methods and join order
  
  New
- 5.2 Access paths, join methods and join order
  
  New
- 5.3 Video: Cardinality estimates and why they go wrong
  
  New
- 5.3 Cardinality estimates and why they go wrong
  
  New
- 5.4 Video: Adaptive plans and adaptive statistics
  
  New
- 5.4 Adaptive plans and adaptive statistics
  
  New
- 5.5 Video: Plan stability and regression analysis
  
  New
- 5.5 Plan stability and regression analysis
  
  New
- 5.L Lab: Reading plans and spotting a regression
  
  Lab New
- Module 5 Quiz: Execution Plans
  
  New 10 xp
Module 6 — Optimiser statistics (empty)

12Lessons · 1 hr 32 min
- 6.1 Video: How the optimiser uses statistics
  
  New
- 6.1 How the optimiser uses statistics
  
  New
- 6.2 Video: Gathering strategy and stale statistics
  
  New
- 6.2 Gathering strategy and stale statistics
  
  New
- 6.3 Video: Histograms and skewed data
  
  New
- 6.3 Histograms and skewed data
  
  New
- 6.4 Video: Extended statistics and column groups
  
  New
- 6.4 Extended statistics and column groups
  
  New
- 6.5 Video: Pending statistics and controlled rollout
  
  New
- 6.5 Pending statistics and controlled rollout
  
  New
- 6.L Lab: Fixing statistics: staleness, histograms and column groups
  
  Lab New
- Module 6 Quiz: Optimiser Statistics
  
  New 10 xp
Module 7 — Influencing the optimiser (empty)

12Lessons · 1 hr 31 min
- 7.1 Video: Hints and when they are justified
  
  New
- 7.1 Hints and when they are justified
  
  New
- 7.2 Video: SQL Plan Management and plan baselines
  
  New
- 7.2 SQL Plan Management and plan baselines
  
  New
- 7.3 Video: SQL profiles and SQL patches
  
  New
- 7.3 SQL profiles and SQL patches
  
  New
- 7.4 Video: Optimiser parameters and their risks
  
  New
- 7.4 Optimiser parameters and their risks
  
  New
- 7.5 Video: SQL Tuning Advisor and SQL Access Advisor
  
  New
- 7.5 SQL Tuning Advisor and SQL Access Advisor
  
  New
- 7.L Lab: SQL Tuning Advisor, profiles and patches
  
  Lab New
- Module 7 Quiz: Influencing the Optimiser
  
  New 10 xp
Module 8 — Application and schema tuning (empty)

12Lessons · 1 hr 31 min
- 8.1 Video: Indexing strategy and index efficiency
  
  New
- 8.1 Indexing strategy and index efficiency
  
  New
- 8.2 Video: Partitioning for performance
  
  New
- 8.2 Partitioning for performance
  
  New
- 8.3 Video: Materialized views and query rewrite
  
  New
- 8.3 Materialized views and query rewrite
  
  New
- 8.4 Video: Bind variables, cursor sharing and parsing
  
  New
- 8.4 Bind variables, cursor sharing and parsing
  
  New
- 8.5 Video: Result cache and client-side caching
  
  New
- 8.5 Result cache and client-side caching
  
  New
- 8.L Lab: Parsing, indexes and a materialized view
  
  Lab New
- Module 8 Quiz: Application and Schema Tuning
  
  New 10 xp
Module 9 — Instance, memory and I/O tuning (empty)

12Lessons · 1 hr 32 min
- 9.1 Video: SGA and PGA sizing with advisors
  
  New
- 9.1 SGA and PGA sizing with advisors
  
  New
- 9.2 Video: Buffer cache and shared pool diagnosis
  
  New
- 9.2 Buffer cache and shared pool diagnosis
  
  New
- 9.3 Video: Redo, undo and temporary space
  
  New
- 9.3 Redo, undo and temporary space
  
  New
- 9.4 Video: I/O subsystem analysis
  
  New
- 9.4 I/O subsystem analysis
  
  New
- 9.5 Video: Latch, mutex and lock contention
  
  New
- 9.5 Latch, mutex and lock contention
  
  New
- 9.L Lab: Memory advice, redo and a lock chain
  
  Lab New
- Module 9 Quiz: Instance, Memory and I/O
  
  New 10 xp
Module 10 — In-Memory, testing and the applications tier (empty)

12Lessons · 1 hr 32 min
- 10.1 Video: Database In-Memory
  
  New
- 10.1 Database In-Memory
  
  New
- 10.2 Video: Database Replay and change testing
  
  New
- 10.2 Database Replay and change testing
  
  New
- 10.3 Video: E-Business Suite concurrent processing
  
  New
- 10.3 E-Business Suite concurrent processing
  
  New
- 10.4 Video: Forms, self-service and WebLogic tuning
  
  New
- 10.4 Forms, self-service and WebLogic tuning
  
  New
- 10.5 Video: Tracing a complaint through every tier and exam readiness
  
  New
- 10.5 Tracing a complaint through every tier and exam readiness
  
  New
- 10.L Lab: In-Memory, concurrent managers and an end-to-end trace
  
  Lab New
- Module 10 Quiz: In-Memory, Testing and Applications Tier
  
  New 10 xp
Final Certification (empty)

1Lessons · 40 min
- Certification Exam: Oracle Applications and Database Performance Tuning
  
  New

Who should attend

Aimed at practitioners responsible for performance in production systems. This is not an entry-level course.

Oracle DBAs taking on performance responsibility
Apps DBAs diagnosing slow E-Business Suite or Fusion Middleware estates
Developers writing SQL and PL/SQL against Oracle at scale
Performance engineers and capacity planners
Support teams handling escalated performance incidents

Assumed knowledge: solid Oracle Database administration, competent SQL and PL/SQL, and familiarity with database architecture. Note that Oracle requires candidates to hold an Oracle Database Administrator Certified Professional credential before sitting the 1Z0-084 exam; delegates who want the certification should confirm their eligibility before booking.

Delivery

Duration
40 hours, delivered as weekday evenings or weekend sessions.

Format
Live instructor-led online, with recordings available to delegates for the duration of the programme. On-site corporate delivery available on request.

Lab environment
Each delegate receives a dedicated database instance with pre-loaded workloads for the duration of the course and for four weeks afterwards.

Included
Course notes, lab guides, exercise solutions and a certificate of completion.

How to enroll

Enrol and pay online on this page. The full fee is ₹15,000 (US$170). You can start with ₹5,000 (US$60) and pay the balance in instalments within 3 months. Pay by card, UPI or net banking, or by PayPal in US dollars. Go to payment. For corporate, on-site or one-to-one training, contact contact@appsolworld.com or call +91 92051 38405.