Why Performance Tuning Matters
- 21m 17s
—Introduction
2m 50s
—Performance Tuning is Not Magic
6m 0s
—Performance Tuning Approach
3m 32s
—Performance Tuning Principles
3m 54s
—Sample Database
4m 59s
Oracle Architecture and Performance Basics
- 48m 51s
—Introduction
1m 25s
—System Scalability
3m 41s
—Oracle Architecture Overview
4m 35s
—Buffer Cache
2m 56s
—Shared Pool
2m 13s
—Program Global Area
2m 24s
—Oracle Architecture Wrap Up
1m 58s
—Performance Metrics
10m 3s
—Performance Tuning and Database Size
5m 55s
—Building Effective Performance Test Databases
3m 36s
—Performance Tuning Database use Scenarios
9m 59s
Connections and Connection Pools
- 28m 15s
—Introduction
4m 55s
—Demo: Connecting With and Without Connection Pools
2m 47s
—Using a Connection Pool in .NET
3m 26s
—Using a Connection Pool in Java
3m 40s
—Connection Pool Best Practices
6m 14s
—Demo: Blocking Connections
4m 35s
—Summary
2m 34s
—Introduction
1m 46s
—The Shared SQL Area
8m 17s
—Contention and Latch Waits
10m 7s
—Matching SQL Statements
6m 13s
—Using Bind Variables in Applications
6m 13s
—Sample Application to Compare Approaches
6m 16s
—Evaluation of Impacts of Bind Variables
4m 6s
Statement Level Performance Tuning
- 34m 45s
—What is an Execution Plan
4m 28s
—Getting an Execution Plan
2m 59s
—What Does an Execution Plan Contain?
2m 54s
—Reading an Execution Plan
4m 25s
—Analyzing an Execution Plan
2m 29s
—Autotrace Introduction
4m 10s
—Autotrace Example in SQL Developer
4m 24s
—Autotrace Example in SQL*Plus
3m 34s
—Data Size and Execution Plans
4m 31s
—Summary
0m 47s
Execution Plans in Depth
- 46m 19s
—Introduction
1m 16s
—Table Access Operations
7m 38s
—Demo: Table Access Operations
5m 18s
—Index Lookup Operations
5m 42s
—Demo: Index Lookup Operations
5m 18s
—Index Full Scan Operations
3m 26s
—Join Operations
8m 33s
—Tuning SQL Statements
9m 4s
Indexing Essentials
- 48m 38s
—Why Indexing Matters
6m 19s
—B-Tree Indexes
4m 54s
—Bitmap Indexes
6m 42s
—Index Column Order Matters
4m 52s
—Demo: Index Column Order
3m 58s
—Index Skip Scan Operations
3m 13s
—Index Selectivity
7m 55s
—Selectivity for Composite Indexes
3m 0s
—Demo: Index Selectivity
4m 43s
—Determining Index Column Order
2m 56s
Advanced Indexing Techniques
- 46m 22s
—Module Outline
1m 42s
—Covering Indexes
7m 55s
—Function Based Indexes Introduction
7m 42s
—Demo - Function Based Indexes: Case Insensitive Search
4m 3s
—Selective Row Indexing With Function Based Indexes
6m 13s
—Demo - Function Based Indexes: Selective Indexing
3m 11s
—Index Compression
6m 29s
—Invisible Indexes
3m 26s
—Demo: Invisible Indexes
4m 3s
—Summary
1m 32s
Application Indexing Practices
- 42m 16s
—Introduction
1m 13s
—What Should I Index?
6m 53s
—Indexing Costs and Overhead
4m 39s
—Demo: Indexing Overhead
4m 17s
—Similar Indexes
1m 49s
—Monitoring Index Usage
4m 26s
—Why isn't Oracle Using My Index?
1m 1s
—Missing Leading Edge of Index
1m 28s
—Index not Selective Enough
1m 29s
—Using a Like Clause and a Leading Wildcard
2m 38s
—Like Clauses and Index Selectivity
3m 5s
—Function in the Where Clause
2m 49s
—Data Type Conversion in the Where Clause
2m 26s
—Outdated Database Statistics
2m 47s
—Summary
1m 10s
Monitoring Oracle Applications
- 35m 11s
—Motivation for Performance Monitoring
6m 10s
—Required Permissions
6m 19s
—Introduction to Queries
0m 50s
—Session Information
2m 8s
—Session Resource Usage
1m 15s
—What Statements are Running Right Now?
1m 15s
—Finding the Worst Performing Statements
4m 38s
—Statements Conducting Full Scan Operations
1m 31s
—Retrieving Execution Plans
0m 48s
—Monitoring Index Usage
2m 14s
—Monitoring Hard Parsing and SQL Using Literal Values
2m 59s
—Table Information
2m 46s
—Index Information
0m 52s
—Summary
1m 19s
Pitfalls and Practices
- 26m 45s
—Module Introduction
1m 27s
—Separating Transactional and Reporting Databases
4m 5s
—Loading too Much Data
3m 8s
—Committing Data too Frequently
6m 20s
—ORMs and Abstraction From the Database
3m 14s
—ORMs and the n+1 Selects Issue
5m 30s
—Summary
2m 59s
