Back

Oracle 12c SQL Performance Features – A Free Tutorial

Learn new SQL performance features offered in Oracle Database 12c!

Oracle Certified Master John Watson and DBA Dave Anderson will demonstrate several Oracle Database 12.x features for SQL performance management including execution plan stabilization, use of adaptive execution features, and how to get the best from new object statistics capabilities.

This is an excerpt from SkillBuilders “Oracle 12c New Features for Administrators” course.

Prerequisites: Students should be a practicing Oracle Database Administrator and familiar with reading execution plans, querying the data dictionary and other DBA-related activities.

About the Presenter
John Watson has been working with Oracle Database for 25 years. John is an Oracle Certified Master DBA. John is the author of several of the Oracle Press Exam Guides. John is a practicing DBA, consultant, teacher, mentor and SkillBuilders’ Director of Oracle Database Services.

This free training is segmented into several separate lessons:

  1. Agenda (1:36) (click on video below)
  2. Introduction to SQL Performance Baselining (Baselining in 11g) (9:39)
  3. SQL Performance Baselining in Oracle Database 12c (6:07)
  4. Adaptive Execution Plans (9:05)
  5. 12c Dynamic Sampling (56)
  6. Summary of Features Discussed (2:16)

Date: Feb 23, 2017

 


NOTE: Some corporate firewalls will not allow videos hosted by YouTube.