Practice 1 - Preparing Practice Environment 1 of 7

Practice 1 - Preparing Practice Environment 2 of 7

Practice 1 - Preparing Practice Environment 3 of 7

Practice 1 - Preparing Practice Environment 4 of 7

Practice 1 - Preparing Practice Environment 5 of 7

Practice 1 - Preparing Practice Environment 6 of 7

Practice 1 - Preparing Practice Environment 7 of 7

Introduction to Oracle Database Performance Tuning 1 of 3

Introduction to Oracle Database Performance Tuning 2 of 3

Introduction to Oracle Database Performance Tuning 3 of 3

About Performance Tuning in IT Systems 1 of 2

About Performance Tuning in IT Systems 2 of 2

Introduction to Oracle Database Performance Tuning Tools

Using Time Model 1 of 3

Using Time Model 2 of 3

Using Time Model 3 of 3

Practice 2 -Using Time Model 1 of 2

Practice 2 -Using Time Model 2 of 2

Using Instance Activity Statistics 1 of 2

Using Instance Activity Statistics 2 of 2

Wait Events 1 of 3

Wait Events 2of 3

Wait Events 3 of 3

Practice 3 - Viewing Instance Activity and Wait Events 1 of 3

Practice 3-Viewing Instance Activity and Wait Events 2 of 3

Practice 3-Viewing Instance Activity and Wait Events 3 of 3

Managing AWR Snapshots 2 of 3

Managing AWR Snapshots 3 of 3

Practice 4-Managing Automatic Workload Repository (AWR) 2 of 2

Using AWR Reports 1 of 9

Using AWR Reports 2 of 9

Using AWR Reports 3 of 9

Using AWR Reports 4 of 9

Using AWR Reports 5 of 9

Using AWR Reports 6 of 9

Using AWR Reports 7 of 9

Using AWR Reports 8 of 9

Using AWR Reports 9 of 9

Using AWR Comparison Reports

Practice 5 - Using AWR Reports 1 of 6

Practice 5 - Using AWR Reports 2 of 6

Practice 5 - Using AWR Reports 3 of 6

Practice 5 - Using AWR Reports 4 of 6

Practice 5 - Using AWR Reports 5 of 6

Practice 5 - Using AWR Reports 6 of 6

Practice 6 - Using AWR SQL Reports

Managing AWR Baseline

Managing AWR Baseline Templates 1 of 2

Managing AWR Baseline Templates 2 of 2

Practice 7 - Using AWR Baselines and Baseline Templates

Metrics and Event Histograms 1 of 2

Metrics and Event Histograms 2 of 2

Server-generated Alerts 1 of 2

Server-generated Alerts 2 of 2

Practice 8 - Using Server-generated Alerts 1 of 2

Practice 8 - Using Server-generated Alerts 2 of 2

Adaptive Thresholds

Using Statspack 1 of 4

Using Statspack 2 of 4

Using Statspack 3 of 4

Using Statspack 4 of 4

Practice 9 - Using Statspack 1 of 2

Practice 9 - Using Statspack 2 of 2

Using Automatic Database Diagnostic Monitor (ADDM) 1 of 3

Using Automatic Database Diagnostic Monitor (ADDM) 2 of 3

Using Automatic Database Diagnostic Monitor (ADDM) 3 of 3

Using ADDM Comparison Report 1 of 2

Using ADDM Comparison Report 2 of 2

Practice 10 - Using Automatic Database Diagnostic Monitor (ADDM) 1 of2

Practice 10 - Using Automatic Database Diagnostic Monitor (ADDM) 2 of 2

Using Active Session History (ASH) 1 of 3

Using Active Session History (ASH) 2 of 3

Using Active Session History (ASH) 3 of 3

Querying ASH 1 of 4

Querying ASH 2 of 4

Querying ASH 3 of 4

Querying ASH 4 of 4

Practice 11 - Using Active Session History (ASH) 1 of 4

Practice 11 - Using Active Session History (ASH) 2 of 4

Practice 11 - Using Active Session History (ASH) 3 of 4

Practice 11 - Using Active Session History (ASH) 4 of 4

Practice 12 - Linking ASH to Its Dimension Views 1 of 4

Practice 12 - Linking ASH to Its Dimension Views 2 of 4

Practice 12 - Linking ASH to Its Dimension Views 3 of 4

Practice 12 - Linking ASH to Its Dimension Views 4 of 4

Introducing Database Services 1 of 4

Introducing Database Services 2 of 4

Introducing Database Services 3 of 4

Introducing Database Services 4 of 4

Practice 13 - Using Database Service Performance Statistics 1 of 2

Practice 13 - Using Database Service Performance Statistics 2 of 2

Using Module Action and Client Identifier 1 of 3

Using Module Action and Client Identifier 2 of 3

Using Module Action and Client Identifier 3 of 3

Practice 14 - Using Module, Action, and Client Identifier Attributes 1 of 4

Practice 14 - Using Module, Action, and Client Identifier Attributes 2 of 4

Practice 14 - Using Module, Action, and Client Identifier Attributes 3 of 4

Practice 14 - Using Module, Action, and Client Identifier Attributes 4 of 4

SQL Tracing 1 of 3

SQL Tracing 2 of 3

SQL Tracing 3 of 3

Using tkprof Utility 1 of 2

Using tkprof Utility 2 of 2

Practice 15 - Tracing SQL Statements using DBMS_MONITOR 1 of 4

Practice 15 - Tracing SQL Statements using DBMS_MONITOR 2 of 4

Practice 15 - Tracing SQL Statements using DBMS_MONITOR 3 of 4

Practice 15 - Tracing SQL Statements using DBMS_MONITOR 4 of 4

Monitoring Database Operations in Real-time 1 of 3

Monitoring Database Operations in Real-time 2 of 3

Monitoring Database Operations in Real-time 3 of 3

Practice 16 - Monitoring Database Operations in Real-time 1 of 3

Practice 16 - Monitoring Database Operations in Real-time 2 of 3

Practice 16 - Monitoring Database Operations in Real-time 3 of 3

Managing the Automated Maintenance Tasks 1 of 2

Managing the Automated Maintenance Tasks 2 of 2

Practice 17 - Managing Automated Maintenance Tasks

Overview of the Tools Covered So Far

Handling Enqueue Waits 1 of 3

Handling Enqueue Waits 2 of 3

Handling Enqueue Waits 3 of 3

Practice 18 - Handling Enqueue Waits 1 of 3

Practice 18 - Handling Enqueue Waits 2 of 3

Practice 18 - Handling Enqueue Waits 3 of 3

Introducing Latches and Mutex 1 of 2

Introducing Latches and Mutex 2 of 2

Handling Latch and Mutex Contention 1 of 2

Handling Latch and Mutex Contention 2 of 2

Handling Cache Buffer Chain (CBC) Latch 1 of 2

Handling Cache Buffer Chain (CBC) Latch 2 of 2

Handling Other Latch Types 1 of 2

Handling Other Latch Types 2 of 2

Practice 19 - Handling Latch and Mutex Contention 1 of 4

Practice 19 - Handling Latch and Mutex Contention 2 of 4

Practice 19 - Handling Latch and Mutex Contention 3 of 4

Practice 19 - Handling Latch and Mutex Contention 4 of 4

Tuning the Shared Pool 1 of 4

Tuning the Shared Pool 2 of 4

Tuning the Shared Pool 3 of 4

Tuning the Shared Pool 4 of 4

Sizing the Shared Pool

Practice 20 - Tuning the Shared Pool 1 of 2

Practice 20 - Tuning the Shared Pool 2 of 2

Caching Session Cursors 1 of 2

Caching Session Cursors 2 of 2

Practice 21 - Caching Session Cursors 1 of 2

Practice 21 - Caching Session Cursors 2 of 2

Managing Server Result Cache 1 of 2

Managing Server Result Cache 2 of 2

Practice 22 - Managing Server Result Cache 1 of 2

Practice 22 - Managing Server Result Cache 2 of 2

Tuning the Buffer Cache 1 of 5

Tuning the Buffer Cache 2 of 5

Tuning the Buffer Cache 3 of 5

Tuning the Buffer Cache 4 of 5

Tuning the Buffer Cache 5 of 5

Practice 23 - Tuning the Buffer Cache 1 of 3

Practice 23 - Tuning the Buffer Cache 2 of 3

Practice 23 - Tuning the Buffer Cache 3 of 3

Using Smart Flash Cache 1 of 3

Using Smart Flash Cache 2 of 3

Using Smart Flash Cache 3 of 3

Practice 24 - Using Smart Flash Cache 1 of 2

Practice 24 - Using Smart Flash Cache 2 of 2

Tuning the PGA 1 of 6

Tuning the PGA 2 of 6

Tuning the PGA 3 of 6

Tuning the PGA 4 of 6

Tuning the PGA 5 of 6

Tuning the PGA 6 of 6

Practice 25 - Tuning the PGA 1 of 3

Practice 25 - Tuning the PGA 2 of 3

Practice 25 - Tuning the PGA 3 of 3

Tuning the Redo Path 1 of 4

Tuning the Redo Path 2 of 4

Tuning the Redo Path 3 of 4

Tuning the Redo Path 4 of 4

Practice 26 - Tuning the Redo Path

Detecting CPU Bottlenecks 1 of 2

Detecting CPU Bottlenecks 2 of 2

Practice 27 - Detecting CPU Bottlenecks 1 of 2

Practice 27 - Detecting CPU Bottlenecks 2 of 2

Tuning Disk IO Operations in Oracle Database 1 of 8

Tuning Disk IO Operations in Oracle Database 2 of 8

Tuning Disk IO Operations in Oracle Database 3 of 8

Tuning Disk IO Operations in Oracle Database 4 of 8

Tuning Disk IO Operations in Oracle Database 5 of 8

Tuning Disk IO Operations in Oracle Database 6 of 8

Tuning Disk IO Operations in Oracle Database 7 of 8

Tuning Disk IO Operations in Oracle Database 8 of 8

Practice 28 - Tuning Disk IO Operations in Oracle Database 1 of 2

Practice 28 - Tuning Disk IO Operations in Oracle Database 2 of 2

Maintaining In-production Indexes for Performance 1 of 5

Maintaining In-production Indexes for Performance 2 of 5

Maintaining In-production Indexes for Performance 3 of 5

Maintaining In-production Indexes for Performance 4 of 5

Maintaining In-production Indexes for Performance 5 of 5

Practice 29 - Performing Index Defragmentation 1 of 2

Practice 29 - Performing Index Defragmentation 2 of 2

Introducing Row Migration and Row Chaining 1 of 2

Introducing Row Migration and Row Chaining 2 of 2

Handling Row Migration and Row Chaining 1 of 3

Handling Row Migration and Row Chaining 2 of 3

Handling Row Migration and Row Chaining 3 of 3

Practice 30 - Handling Row Migration and Row Chaining 1 of 3

Practice 30 - Handling Row Migration and Row Chaining 2 of 3

Practice 30 - Handling Row Migration and Row Chaining 3 of 3

Diagnosing Table Fragmentation 1 of 2

Diagnosing Table Fragmentation 2 of 2

Practice 31 - Diagnosing Table Fragmentation

Using Table Compression 1 of 3

Using Table Compression 2 of 3

Using Table Compression 3 of 3

Practice 32 - Using Table Compression 1 of 2

Practice 32 - Using Table Compression 2 of 2

Introducing In-Memory Column Store 1 of 3

Introducing In-Memory Column Store 2 of 3

Introducing In-Memory Column Store 3 of 3

Practice 33 - Introducing In-Memory Column Store

Optimizing Database Connection 1 of 6

Optimizing Database Connection 2 of 6

Optimizing Database Connection 3 of 6

Optimizing Database Connection 4 of 6

Optimizing Database Connection 5 of 6

Optimizing Database Connection 6 of 6

Practice 34 - Optimizing Database Connection

Monitoring Oracle Database Performance using EM Database Express

Demo - Using Oracle EM Express for Performance Tuning 1 of 5

Demo - Using Oracle EM Express for Performance Tuning 2 of 5

Demo - Using Oracle EM Express for Performance Tuning 3 of 5

Demo - Using Oracle EM Express for Performance Tuning 4 of 5

Demo - Using Oracle EM Express for Performance Tuning 5 of 5

Monitoring OS Performance using Linux Utilities 1 of 2

Monitoring OS Performance using Linux Utilities 2 of 2

Practice 35 - Monitoring OS Performance using Linux Utilities 1 of 5

Practice 35 - Monitoring OS Performance using Linux Utilities 2 of 5

Practice 35 - Monitoring OS Performance using Linux Utilities 3 of 5

Practice 35 - Monitoring OS Performance using Linux Utilities 4 of 5

Practice 35 - Monitoring OS Performance using Linux Utilities 5 of 5

Using OSWatcher Black Box 1 of 3

Using OSWatcher Black Box 2 of 3

Using OSWatcher Black Box 3 of 3

Practice 36 - Using OSWatcher Black Box 1 of 2

Practice 36 - Using OSWatcher Black Box 2 of 2

Using SQL Performance Analyzer 1 of 3

Using SQL Performance Analyzer 2 of 3

Using SQL Performance Analyzer 3 of 3

Practice 37 - Using SQL Performance Analyzer 1 of 2

Practice 37 - Using SQL Performance Analyzer 2 of 2

Using Database Replay 1 of 4

Using Database Replay 2 of 4

Using Database Replay 3 of 4

Using Database Replay 4 of 4

Practice 38 - Using Database Replay 1 of 7

Practice 38 - Using Database Replay 2 of 7

Practice 38 - Using Database Replay 3 of 7

Practice 38 - Using Database Replay 4 of 7

Practice 38 - Using Database Replay 5 of 7

Practice 38 - Using Database Replay 6 of 7

Practice 38 - Using Database Replay 7 of 7

Course Documents