MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Oracle Performance Tuning

Course Summary

This tutorial will provide a good foundation of Oracle performance tuning along with handy tips for issue resolution.

  • +

    Course Syllabus

    • Introduction
      • Introduction and Course Layout
    • Performance Tuning Overview
      • Common Causes of Performance Tuning
      • Different Approach
      • Performance Tuning Methodology
      • Baseline
    • Sources of Tuning Information
      • Alert Log
      • Trace Files
      • Automatic Workflow Repository
      • Application Tracing and Performace Tuning views
    • Understanding Database Statistics
      • Database Statistics
      • Oracle Optimizer
      • Fragmentation and Maintenance Plan
    • SQL Tuning
      • TKPROF
      • Explain Plan, Autotrace and General Guidelines of SQL Tuning
    • Instance Tuning
      • Instance Tuning
    • Miscellaneous Tuning Techniques
      • Plan Stability and Partition

Course Fee:
USD 50

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations , Data & Information Management and E-Commerce Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top