Course curriculum

  • 1

    Introducing the course

  • 2

    Practice 1 - Preparing Practice Environment

    • 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

  • 3

    Introduction to Oracle Database Performance Tuning

    • 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

  • 4

    About Performance Tuning in IT Systems

    • About Performance Tuning in IT Systems 1 of 2

    • About Performance Tuning in IT Systems 2 of 2

  • 5

    Introduction to Oracle Database Performance Tuning Tools

    • Introduction to Oracle Database Performance Tuning Tools

  • 6

    Using Time Model

    • Using Time Model 1 of 3

    • Using Time Model 2 of 3

    • Using Time Model 3 of 3

  • 7

    Practice 2 -Using Time Model

    • Practice 2 -Using Time Model 1 of 2

    • Practice 2 -Using Time Model 2 of 2

  • 8

    Using Instance Activity Statistics

    • Using Instance Activity Statistics 1 of 2

    • Using Instance Activity Statistics 2 of 2

  • 9

    Wait Events

    • Wait Events 1 of 3

    • Wait Events 2of 3

    • Wait Events 3 of 3

  • 10

    Practice 3 - Viewing Instance Activity and Wait Events

    • 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

  • 11

    Overview to Automatic Workload Repository (AWR)

  • 12

    Managing AWR Snapshots

  • 13

    Practice 4 - Managing Automatic Workload Repository (AWR)

  • 14

    Using AWR Reports

    • 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

  • 15

    Using AWR Comparison Reports

    • Using AWR Comparison Reports

  • 16

    Practice 5 - Using AWR 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

  • 17

    Practice 6 - Using AWR SQL Reports

    • Practice 6 - Using AWR SQL Reports

  • 18

    Managing AWR Baselines

    • Managing AWR Baseline

  • 19

    Managing AWR Baseline Templates

    • Managing AWR Baseline Templates 1 of 2

    • Managing AWR Baseline Templates 2 of 2

  • 20

    Practice 7 - Using AWR Baselines and Baseline Templates

    • Practice 7 - Using AWR Baselines and Baseline Templates

  • 21

    Metrics and Event Histograms

    • Metrics and Event Histograms 1 of 2

    • Metrics and Event Histograms 2 of 2

  • 22

    Server-generated Alerts

    • Server-generated Alerts 1 of 2

    • Server-generated Alerts 2 of 2

  • 23

    Practice 8 - Using Server-generated Alerts

    • Practice 8 - Using Server-generated Alerts 1 of 2

    • Practice 8 - Using Server-generated Alerts 2 of 2

  • 24

    Adaptive Thresholds

    • Adaptive Thresholds

  • 25

    Using Statspack

    • Using Statspack 1 of 4

    • Using Statspack 2 of 4

    • Using Statspack 3 of 4

    • Using Statspack 4 of 4

  • 26

    Practice 9 - Using Statspack

    • Practice 9 - Using Statspack 1 of 2

    • Practice 9 - Using Statspack 2 of 2

  • 27

    Using Automatic Database Diagnostic Monitor (ADDM)

    • 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

  • 28

    Using ADDM Comparison Report

    • Using ADDM Comparison Report 1 of 2

    • Using ADDM Comparison Report 2 of 2

  • 29

    Practice 10 - Using Automatic Database Diagnostic Monitor (ADDM)

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

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

  • 30

    Using Active Session History (ASH)

    • Using Active Session History (ASH) 1 of 3

    • Using Active Session History (ASH) 2 of 3

    • Using Active Session History (ASH) 3 of 3

  • 31

    Querying ASH

    • Querying ASH 1 of 4

    • Querying ASH 2 of 4

    • Querying ASH 3 of 4

    • Querying ASH 4 of 4

  • 32

    Practice 11 - Using Active Session History (ASH)

    • 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

  • 33

    Practice 12 - Linking ASH to Its Dimension Views

    • 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

  • 34

    Introducing Database Services

    • Introducing Database Services 1 of 4

    • Introducing Database Services 2 of 4

    • Introducing Database Services 3 of 4

    • Introducing Database Services 4 of 4

  • 35

    Practice 13 - Using Database Service Performance Statistics

    • Practice 13 - Using Database Service Performance Statistics 1 of 2

    • Practice 13 - Using Database Service Performance Statistics 2 of 2

  • 36

    Using Module Action and Client Identifier

    • 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

  • 37

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

    • 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

  • 38

    SQL Tracing

    • SQL Tracing 1 of 3

    • SQL Tracing 2 of 3

    • SQL Tracing 3 of 3

  • 39

    Using tkprof Utility

    • Using tkprof Utility 1 of 2

    • Using tkprof Utility 2 of 2

  • 40

    Practice 15 - Tracing SQL Statements using DBMS_MONITOR

    • 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

  • 41

    Monitoring Database Operations in Real-time

    • 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

  • 42

    Practice 16 - Monitoring Database Operations in Real-time

    • 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

  • 43

    Managing the Automated Maintenance Tasks

    • Managing the Automated Maintenance Tasks 1 of 2

    • Managing the Automated Maintenance Tasks 2 of 2

  • 44

    Practice 17 - Managing Automated Maintenance Tasks

    • Practice 17 - Managing Automated Maintenance Tasks

  • 45

    Overview of the Tools Covered So Far

    • Overview of the Tools Covered So Far

  • 46

    Handling Enqueue Waits

    • Handling Enqueue Waits 1 of 3

    • Handling Enqueue Waits 2 of 3

    • Handling Enqueue Waits 3 of 3

  • 47

    Practice 18 - Handling Enqueue Waits

    • Practice 18 - Handling Enqueue Waits 1 of 3

    • Practice 18 - Handling Enqueue Waits 2 of 3

    • Practice 18 - Handling Enqueue Waits 3 of 3

  • 48

    Introducing Latches and Mutex

    • Introducing Latches and Mutex 1 of 2

    • Introducing Latches and Mutex 2 of 2

  • 49

    Handling Latch and Mutex Contention

    • Handling Latch and Mutex Contention 1 of 2

    • Handling Latch and Mutex Contention 2 of 2

  • 50

    Handling Cache Buffer Chain (CBC) Latch

    • Handling Cache Buffer Chain (CBC) Latch 1 of 2

    • Handling Cache Buffer Chain (CBC) Latch 2 of 2

  • 51

    Handling Other Latch Types

    • Handling Other Latch Types 1 of 2

    • Handling Other Latch Types 2 of 2

  • 52

    Practice 19 - Handling Latch and Mutex Contention

    • 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

  • 53

    Tuning the Shared Pool

    • 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

  • 54

    Sizing the Shared Pool

    • Sizing the Shared Pool

  • 55

    Practice 20 - Tuning the Shared Pool

    • Practice 20 - Tuning the Shared Pool 1 of 2

    • Practice 20 - Tuning the Shared Pool 2 of 2

  • 56

    Caching Session Cursors

    • Caching Session Cursors 1 of 2

    • Caching Session Cursors 2 of 2

  • 57

    Practice 21 - Caching Session Cursors

    • Practice 21 - Caching Session Cursors 1 of 2

    • Practice 21 - Caching Session Cursors 2 of 2

  • 58

    Managing Server Result Cache

    • Managing Server Result Cache 1 of 2

    • Managing Server Result Cache 2 of 2

  • 59

    Practice 22 - Managing Server Result Cache

    • Practice 22 - Managing Server Result Cache 1 of 2

    • Practice 22 - Managing Server Result Cache 2 of 2

  • 60

    Tuning the Buffer Cache

    • 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

  • 61

    Practice 23 - Tuning the Buffer Cache

    • 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

  • 62

    Using Smart Flash Cache

    • Using Smart Flash Cache 1 of 3

    • Using Smart Flash Cache 2 of 3

    • Using Smart Flash Cache 3 of 3

  • 63

    Practice 24 - Using Smart Flash Cache

    • Practice 24 - Using Smart Flash Cache 1 of 2

    • Practice 24 - Using Smart Flash Cache 2 of 2

  • 64

    Tuning the PGA

    • 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

  • 65

    Practice 25 - Tuning the PGA

    • Practice 25 - Tuning the PGA 1 of 3

    • Practice 25 - Tuning the PGA 2 of 3

    • Practice 25 - Tuning the PGA 3 of 3

  • 66

    Tuning the Redo Path

    • 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

  • 67

    Practice 26 - Tuning the Redo Path

    • Practice 26 - Tuning the Redo Path

  • 68

    Detecting CPU Bottlenecks

    • Detecting CPU Bottlenecks 1 of 2

    • Detecting CPU Bottlenecks 2 of 2

  • 69

    Practice 27 - Detecting CPU Bottlenecks

    • Practice 27 - Detecting CPU Bottlenecks 1 of 2

    • Practice 27 - Detecting CPU Bottlenecks 2 of 2

  • 70

    Tuning Disk IO Operations in Oracle Database

    • 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

  • 71

    Practice 28 - Tuning Disk IO Operations in Oracle Database

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

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

  • 72

    Maintaining In-production Indexes for Performance

    • 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

  • 73

    Practice 29 - Performing Index Defragmentation

    • Practice 29 - Performing Index Defragmentation 1 of 2

    • Practice 29 - Performing Index Defragmentation 2 of 2

  • 74

    Introducing Row Migration and Row Chaining

    • Introducing Row Migration and Row Chaining 1 of 2

    • Introducing Row Migration and Row Chaining 2 of 2

  • 75

    Handling Row Migration and Row Chaining

    • 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

  • 76

    Practice 30 - Handling Row Migration and Row Chaining

    • 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

  • 77

    Diagnosing Table Fragmentation

    • Diagnosing Table Fragmentation 1 of 2

    • Diagnosing Table Fragmentation 2 of 2

  • 78

    Practice 31 - Diagnosing Table Fragmentation

    • Practice 31 - Diagnosing Table Fragmentation

  • 79

    Using Table Compression

    • Using Table Compression 1 of 3

    • Using Table Compression 2 of 3

    • Using Table Compression 3 of 3

  • 80

    Practice 32 - Using Table Compression

    • Practice 32 - Using Table Compression 1 of 2

    • Practice 32 - Using Table Compression 2 of 2

  • 81

    Introducing In-Memory Column Store

    • Introducing In-Memory Column Store 1 of 3

    • Introducing In-Memory Column Store 2 of 3

    • Introducing In-Memory Column Store 3 of 3

  • 82

    Practice 33 - Introducing In-Memory Column Store

    • Practice 33 - Introducing In-Memory Column Store

  • 83

    Optimizing Database Connection

    • 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

  • 84

    Practice 34 - Optimizing Database Connection

    • Practice 34 - Optimizing Database Connection

  • 85

    Monitoring Oracle Database Performance using EM Database Express

    • Monitoring Oracle Database Performance using EM Database Express

  • 86

    Demo - Using Oracle EM Express for Performance Tuning

    • 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

  • 87

    Monitoring OS Performance using Linux Utilities

    • Monitoring OS Performance using Linux Utilities 1 of 2

    • Monitoring OS Performance using Linux Utilities 2 of 2

  • 88

    Practice 35 - Monitoring OS Performance using Linux Utilities

    • Practice 35 - Monitoring OS Performance using Linux Utilities 1 of 2

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

  • 89

    Using OSWatcher Black Box

    • Using OSWatcher Black Box 1 of 3

    • Using OSWatcher Black Box 2 of 3

    • Using OSWatcher Black Box 3 of 3

  • 90

    Practice 36 - Using OSWatcher Black Box

    • Practice 36 - Using OSWatcher Black Box 1 of 2

    • Practice 36 - Using OSWatcher Black Box 2 of 2

  • 91

    Using SQL Performance Analyzer

    • Using SQL Performance Analyzer 1 of 3

    • Using SQL Performance Analyzer 2 of 3

    • Using SQL Performance Analyzer 3 of 3

  • 92

    Practice 37 - Using SQL Performance Analyzer

    • Practice 37 - Using SQL Performance Analyzer 1 of 2

    • Practice 37 - Using SQL Performance Analyzer 2 of 2

  • 93

    Using Database Replay

    • Using Database Replay 1 of 4

    • Using Database Replay 2 of 4

    • Using Database Replay 3 of 4

    • Using Database Replay 4 of 4

  • 94

    Practice 38 - Using Database Replay

    • 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