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