Oracle – Database Performance Fine Tuning

Created by  Wattlenet Academy

  • $199.00

This course includes:
  • 0 hrs on-demand video
  • 9 Topics
  • Full lifetime access
  • Access on mobile and TV


Course Description:

Oracle – Database and SQL Performance Tuning


Course Objectives:

To give good understanding on how to diagnose and fix Oracle database and sql tuning performance issues to have overall better throughput and scalability of system

Trainer – Harmandeep Singh

Max Class Size: 15         Pre-reqs: Oracle archirecture or development knowledge

Duration: 1 day (6 hours)

Class requirements: Laptop/PC, wi-fi access, Chrome browser



Attendees will be able to understand the Database and SQL Performance tuning from practical perspective and then able to do better at jobs and real time systems while triaging real time issues

Course Content

  • Oracle – Database Performance Fine Tuning
    • Introduction to SQL Tuning
    • SQL Performance Methodology
    • Query Optimizer Fundamentals
    • Generating and Displaying Execution Plans
    • Reading Execution Plans
    • Nested loops, Hash joins
    • Instance Tuning
    • Reading AWR reports and Sql traces
Write a review

Write a review

Please login or register to review

Tags: Software Development