Oracle Database 12c Performance Tuning and Optimization
This course will teach you how to perform maintenance and manage performance in Oracle Database 12c, and overlaps heavily with the OCP exam objectives.
What you'll learn
It seems that most Oracle Database administrators enjoy twiddling and tweaking their production Oracle databases/instances to make them run as efficiently as possible. This course will teach you how to perform maintenance and manage performance. In addition, this course overlaps heavily with the OCP exam objectives.
Table of contents
- Overview 2m
- A Reference 1m
- About Oracle Performance Tuning 3m
- Oracle Database Tuning Tools 3m
- Approaches to Performance Tuning 4m
- The Automatic Workload Repository (AWR) 2m
- Enabling ADDM 0m
- Demo 1: Enabling and Configuring ADDM 5m
- More About DB Time 3m
- The Most Common Database Performance Problems 1m
- Methods for Generating ADDM Reports 1m
- Demo 2: Accessing the AWR With SQL Developer 3m
- Interpreting ADDM Findings 1m
- Summary 1m
- Overview 2m
- The Problem in a Nutshell 2m
- Introducing Database Resource Manager 3m
- Resource Manager Components 2m
- Demo 1: Enabling a Resource Plan 3m
- Demo 2: Configuring Database Resource Manager 4m
- More About Resource Plans 2m
- A Simple Resource Plan 2m
- Built-In Resource Plans 1m
- Built-In Consumer Groups 0m
- Consumer Group Mapping Rules 1m
- Managing Resource Consumer Groups 1m
- Resource Manager in a Multitenant Environment 2m
- Demo 3: Creating a Resource Plan 6m
- Summary 2m
- Overview 2m
- What the Oracle Scheduler Is 1m
- What the Oracle Scheduler Is Not 1m
- What Can We Do With the Scheduler? 3m
- Oracle Scheduler Object Rogue's Gallery 3m
- More About Scheduler Jobs 2m
- Windows 3m
- How Does This Stuff Fit Together? 2m
- Demo 1: Touring the Oracle Database 12c Scheduler 5m
- Demo 2: Building Jobs With SQL Developer 5m
- Summary 1m
- Overview 1m
- The Problem in a Nutshell 2m
- Data Concurrency and Consistency 3m
- The Difference Between Locks and Latches 3m
- Oracle Database 12c Locking Rules 3m
- How Oracle Manages Concurrency 3m
- Locks and Deadlocks 2m
- How to Resolve Lock Conflicts 1m
- Demo 1: Managing Data Consistency 2m
- Demo 2: Taking Charge of Data Concurrency 6m
- Summary 1m
About the author
Timothy Warner is a Microsoft Most Valuable Professional (MVP) in Cloud and Datacenter Management who is based in Nashville, TN. His professional specialties include Microsoft Azure, cross-platform PowerShell, and all things Windows Server-related. You can reach Tim via Twitter (@TechTrainerTim), LinkedIn or his blog, AzureDepot.com.