Autoplay
Autocomplete
Previous Lecture
Complete and Continue
Oracle Database 19c: SQL Tuning
First Section
DOWNLOAD - Slides
DOWNLOAD - Lab Guide
Introduction and SQL Performance Fundamentals
Introduction and SQL Performance Fundamentals (55:06)
Optimizer Fundamentals
Processing of SQL Statements (56:30)
Optimizer Concepts (41:35)
Execution Plans
Overview of Execution Plans (23:18)
How to Read Execution Plan? (10:33)
Generating Execution Plans using SQL*Plus Autotrace (16:56)
Generating Execution Plans using EXPLAIN PLAN (65:31)
Access Paths
Access Paths (46:10)
LAB PRACTICES: Access Paths (12:29)
Join Methods
Join Methods (43:59)
LAB PRACTICES: Join Methods (7:41)
Optimizer Statistics
About Optimizer Statistics (8:39)
When and How Database Gathers Optimizer Statistics? (19:18)
Configuring Options for Optimizer Statistics Gathering (14:58)
Gathering Optimizer Statistics (8:13)
LAB PRACTICES: Gathering Optimizer Statistics (38:42)
Histograms (28:58)
LAB PRACTICES: Histograms (10:31)
Extended Statistics - Column Group Statistics (26:40)
Extended Statistics - Expression Statistics (4:32)
LAB PRACTICES: Extended Statistics (21:03)
Controlling the use of Optimizer Statistics (25:46)
LAB PRACTICES: Controlling the use of Optimizer Statistics (39:18)
Optimizer Controls
Using Hints (80:27)
LAB PRACTICES: Using Hints (63:56)
Cursor Sharing, Adaptive Cursor Sharing (63:34)
SQL Monitoring
Monitoring SQLs (52:30)
SQL Tracing
Tracing SQLs (116:37)
SQL Tuning Sets (STS)
SQL Tuning Sets (STS) (60:52)
SQL Tuning Advisor
SQL Tuning Advisor - Concepts (40:09)
LAB PRACTICES: SQL Tuning Advisor (38:00)
SQL Access Advisor
SQL Access Advisor (59:56)
SQL Profiles
SQL Profiles (61:25)
SQL Plan Management
SQL Plan Management - Concepts (70:40)
LAB PRACTICES: SQL Plan Management (68:23)
Migrating Stored Outlines to SQL Plan Baselines
Migrating Stored Outlines to SQL Plan Baselines (42:21)
Join Methods
Lecture content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock