Oracle 12c Performance Tuning: Introduction


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level


Overview/Description
The Oracle RDBMS engine has been around for many years, and over the course of its existence, there have been many methodologies in how to go about troubleshooting performance problems. This course will provide a modern-day approach on how to confront these types of challenges, with particular attention to making use of features available in the 12c version of the database. This course is one of a series in the SkillSoft learning path that cover the objectives for the Oracle Database 12c: Performance Management and Tuning exam (1ZO-064).

Target Audience
Database Administrators, Application Developers, Technical Consultants and learners looking to obtain the Oracle Database 12c: Performance Management and Tuning certification.

Prerequisites
None

Expected Duration (hours)
1.2

Lesson Objectives

Oracle 12c Performance Tuning: Introduction

  • start the course
  • define the components of performance management
  • identify who is responsible for performance management of the Oracle database
  • describe the Oracle tuning methodology
  • describe effective tuning goals
  • list the steps of a general tuning session
  • identify tuning objectives
  • examine top timed events in an AWR report
  • define the concept of DB time
  • describe CPU and wait time tuning dimensions
  • define the time model
  • work with the dynamic performance views
  • describe database wait events
  • describe database wait classes
  • use SQL to display wait event statistics
  • describe commonly observed wait events
  • describe Oracle Enterprise Manager
  • describe the Oracle EM architecture
  • use OEM to view the performance hub page
  • describe the instance alert log
  • describe user trace files
  • describe how to define and limit the scope of a problem
  • list common tuning problems
  • describe the tuning life cycle phases
  • evaluate the balance between performance and business requirements
  • work with Oracle support to file a performance service request
  • use SQL commands to query the dynamic performance views to view tuning information

    • Course Number:
    od_pmte_a01_it_enus

    Expertise Level
    Intermediate