• Online, Self-Paced
Course 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).

Learning Objectives

Ground Rules for Performance Management

  • 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

Basic Tuning Diagnostics

  • 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

Dynamic Performance Views

  • 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

Performance Diagnosis Tools

  • 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


Scoping Performance Issues

  • 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


Practice: Basic Tuning Diagnostics

  • use SQL commands to query the dynamic performance views to view tuning information


Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Systems Administration