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 Database 12c Performance Tuning and Optimization

Course Summary

This course will teach you how to perform maintenance and manage performance in Oracle Database 12c, and overlaps heavily with the OCP exam objectives.

  • +

    Course Syllabus

    Introduction to Oracle Database 12c Performance Tuning
    - 29m 57s

    —Overview 1m 50s
    —A Reference 1m 15s
    —About Oracle Performance Tuning 3m 22s
    —Oracle Database Tuning Tools 2m 46s
    —Approaches to Performance Tuning 4m 2s
    —The Automatic Workload Repository (AWR) 1m 38s
    —Enabling ADDM 0m 17s
    —Demo 1: Enabling and Configuring ADDM 5m 0s
    —More About DB Time 2m 32s
    —The Most Common Database Performance Problems 1m 8s
    —Methods for Generating ADDM Reports 0m 45s
    —Demo 2: Accessing the AWR With SQL Developer 2m 58s
    —Interpreting ADDM Findings 1m 1s
    —Summary 1m 16s
    Monitoring Oracle Database 12c Performance
    - 31m 30s

    —Overview 1m 38s
    —A Resource 0m 59s
    —ADDM Analysis and Recommendations 2m 30s
    —About Real-Time ADDM 1m 37s
    —Demo 1: Using ADDM and Real-Time ADDM 8m 46s
    —Active Session History (ASH) Analytics 2m 7s
    —Using the Advisory Framework 1m 51s
    —Demo 2: Deeper Into ASH Analytics 5m 44s
    —Demo 3: Introducing the Advisory Framework 3m 55s
    —Summary 2m 18s
    Tuning SQL in Oracle Database 12c
    - 27m 24s
    Managing Resources With Database Resource Manager
    - 32m 19s
    Automating Tasks With the Oracle Database 12c Scheduler
    - 28m 56s
    Managing Oracle Database 12c Data Concurrency
    - 26m 54s

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Development & Implementations and Data & Information Management 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