Course details

Oracle 12c Performance Tuning: Measuring and Maintaining SQL Performance

Oracle 12c Performance Tuning: Measuring and Maintaining SQL Performance

Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level

Once poorly performing SQL is identified, and changes proposed, those changes need to be validated to ensure that they will yield the desired effect. This course will show how tools such as the SQL Performance Analyzer and SQL Tuning Advisor can be used to achieve this goal. This course is one of a series in the Skillsoft learning path that covers the objectives for the Oracle Database 12c: Performance Management and Tuning exam (1ZO-064).

Target Audience
Database Administrators, Application Developers, Technical Consultants


Expected Duration (hours)

Lesson Objectives

Oracle 12c Performance Tuning: Measuring and Maintaining SQL Performance

  • start the course
  • use Real Application Testing
  • use SQL Performance Analyzer
  • create and compare SQL Performance Analyzer tasks
  • use the SQL Tuning Advisor to assist in tuning regressing SQL statements
  • describe the PL/SQL functions used to manipulate the SQL Performance Analyzer
  • describe the fundamental methods for maintaining SQL performance
  • describe the options available when configuring Optimizer statistics
  • describe the concept of deferred statistics publishing
  • recognize the concept of automatic SQL tuning
  • describe the use of the SQL Tuning Advisor
  • identify the use of the SQL Access Advisor
  • recognize the concept and architecture of SQL plan baselines
  • describe how SQL plan baselines are created and evolve over time
  • describe adaptive SQL plan management
  • recognize how SQL plan selection works and list scenarios under which it comes into play
  • list the methods available to configure the SPM infrastructure and show the interaction with Enterprise Manager
  • define the concept of Database Replay
  • describe the architecture of the components that make up Database Replay
  • describe the workflow implementation of Database Replay within Enterprise Manager
  • describe considerations for capturing a workload
  • describe how to properly cater for Database Replay tasks
  • describe the process of replaying a workload
  • compare the results of a workload replay report
  • list the packages and views associated with using and configuring Database Replay
  • use the DBMS_SPM package to fix a particular execution plan for a given SQL statement
  • Course Number:

    Expertise Level