Oracle Database 12c Performance Tuning and Optimization

—Overview 1m 35s
—About Optimizer Statistics 3m 20s
—Gathering Statistics 1m 12s
—Demo 1: Managing Optimizer Statistics 4m 14s
—The SQL Tuning Advisor 3m 30s
—The SQL Access Advisor 2m 16s
—Demo 2: Using the SQL Tuning Advisor 5m 4s
—Demo 3: Using the SQL Access Advisor 4m 36s
—Summary 1m 33s

—Overview 1m 35s
—The Problem in a Nutshell 2m 22s
—Introducing Database Resource Manager 3m 7s
—Resource Manager Components 2m 27s
—Demo 1: Enabling a Resource Plan 3m 3s
—Demo 2: Configuring Database Resource Manager 3m 51s
—More About Resource Plans 1m 53s
—A Simple Resource Plan 1m 36s
—Built-In Resource Plans 0m 44s
—Built-In Consumer Groups 0m 17s
—Consumer Group Mapping Rules 1m 13s
—Managing Resource Consumer Groups 0m 55s
—Resource Manager in a Multitenant Environment 1m 33s
—Demo 3: Creating a Resource Plan 5m 58s
—Summary 1m 37s

—Overview 2m 19s
—What the Oracle Scheduler Is 0m 44s
—What the Oracle Scheduler Is Not 1m 11s
—What Can We Do With the Scheduler? 3m 24s
—Oracle Scheduler Object Rogue's Gallery 3m 14s
—More About Scheduler Jobs 1m 40s
—Windows 2m 42s
—How Does This Stuff Fit Together? 1m 37s
—Demo 1: Touring the Oracle Database 12c Scheduler 5m 20s
—Demo 2: Building Jobs With SQL Developer 5m 26s
—Summary 1m 15s

—Overview 1m 28s
—The Problem in a Nutshell 1m 58s
—Data Concurrency and Consistency 2m 41s
—The Difference Between Locks and Latches 2m 55s
—Oracle Database 12c Locking Rules 2m 41s
—How Oracle Manages Concurrency 2m 44s
—Locks and Deadlocks 2m 19s
—How to Resolve Lock Conflicts 0m 56s
—Demo 1: Managing Data Consistency 2m 13s
—Demo 2: Taking Charge of Data Concurrency 5m 48s
—Summary 1m 4s