Oracle Database Performance Tuning

Free Download Oracle Database Performance Tuning
Last updated 2/2024
MP4 | Video: h264, 1280×720 | Audio: AAC, 44.1 KHz
Language: English | Size: 10.16 GB | Duration: 27h 29m
Do you want to be an Oracle Database Performance Tuning Professional? If yes, do not miss this opportunity!

What you’ll learn
Oracle database performance tuning
Requirements
Oracle SQL language, basic level
Oracle database architecture, accomplished level
Linux operating system, basic level
PC with Windows operating system, RAM: 8 GB
Description
Do you want to join the 1% DBAs who really know how to achieve the Oracle Database Performance Tuning activities?Have you ever been called for a slow database or a sluggish session and you did not know where to start?Are you wondering how you can predict if the database will face a performance issue soon?If yes, then you are in the right place.The course does not only demonstrate the Oracle database performance tuning concepts, you will gain hands-on experience on using the performance tuning tools.The skills that you will learn in this course include the following:Determine the bottlenecks in low-performance Oracle databasesUse Oracle database performance tuning tools, like: AWR, ASH, V$ views, SQL tracing, real-time monitoring, and EM ExpressPropose solutions to database performance issuesImplement Oracle methodology in performance tuningContent and OverviewInformation presented in this course provides the Oracle DBAs the knowledge and experience to perform Oracle databases performance tuning activities.After every concepts lecture, you will implement practical exercises. To guide you on implementing the practices, the practice lectures are supported by video-based demonstrations and the downloadable guide documents.Starting with introducing Oracle database performance tuning, this course will take you all the away from basics of using Oracle database performance tuning tools up to to propose solutions to performance issues. You will understand how Oracle methodology works and learn how to implement it.This course will cover all the complicated topics that are included in Oracle database performance tuning topic, such as the following:Oracle performance statistics, wait events, and metricsOracle performance tuning tools, like: AWR, ASH, V$ views, SQL tracing, and EM ExpressTuning Oracle database componentsTuning database consumption from system resources: CPU, memory, disk I/O, and networkManaging in-production tables and indexes for performanceSQL Performance AnalyzerDatabase ReplayThis training session is entirely about making Oracle database more efficient, understanding the root causes of performance problems, and suggest solutions to resolve them.Instead of thinking of increasing system resource as a first “tuning” choice, this course teaches you about identifying the bottleneck and revive them.Finally, this course is not just a list of “tips and tricks”, it will go deep into topic. It gives you the knowledge and tools for systematic Oracle database performance tuning.Take this opportunity and join the author in exploring Oracle Database Performance Tuning skills!
Overview
Section 1: Introduction
Lecture 1 Introducing the Course
Section 2: Practice 1 – Preparing Practice Environment
Lecture 2 Practice 1 – Preparing Practice Environment 2 of 7
Lecture 3 Practice 1 – Preparing Practice Environment 1 of 7
Lecture 4 Practice 1 – Preparing Practice Environment 3 of 7
Lecture 5 Practice 1 – Preparing Practice Environment 4 of 7
Lecture 6 Practice 1 – Preparing Practice Environment 5 of 7
Lecture 7 Practice 1 – Preparing Practice Environment 6 of 7
Lecture 8 Practice 1 – Preparing Practice Environment 7 of 7
Section 3: Introduction to Oracle Database Performance Tuning
Lecture 9 Introduction to Oracle Database Performance Tuning 1 of 3
Lecture 10 Introduction to Oracle Database Performance Tuning 2 of 3
Lecture 11 Introduction to Oracle Database Performance Tuning 3 of 3
Section 4: About Performance Tuning in IT Systems
Lecture 12 About Performance Tuning in IT Systems 1 of 2
Lecture 13 About Performance Tuning in IT Systems 2 of 2
Section 5: Introduction to Oracle Database Performance Tuning Tools
Lecture 14 Introduction to Oracle Database Performance Tuning Tools
Section 6: Using Time Model
Lecture 15 Using Time Model 1 of 3
Lecture 16 Using Time Model 2 of 3
Lecture 17 Using Time Model 3 of 3
Lecture 18 Practice 2 -Using Time Model 1 of 2
Lecture 19 Practice 2 -Using Time Model 2 of 2
Section 7: Using Instance Activity Statistics
Lecture 20 Using Instance Activity Statistics 1 of 2
Lecture 21 Using Instance Activity Statistics 2 of 2
Section 8: Wait Events
Lecture 22 Wait Events 1 of 3
Lecture 23 Wait Events 2 of 3
Lecture 24 Wait Events 3 of 3
Lecture 25 Practice 3 – Viewing Instance Activity and Wait Events 1 of 3
Lecture 26 Practice 3 – Viewing Instance Activity and Wait Events 2 of 3
Lecture 27 Practice 3 – Viewing Instance Activity and Wait Events 3 of 3
Section 9: Using AWR
Lecture 28 Overview to Automatic Workload Repository (AWR)
Lecture 29 Managing AWR Snapshots 1 of 3
Lecture 30 Managing AWR Snapshots 2 of 3
Lecture 31 Managing AWR Snapshots 3 of 3
Lecture 32 Practice 4 – Managing Automatic Workload Repository (AWR) 1 of 2
Lecture 33 Practice 4 – Managing Automatic Workload Repository (AWR) 2 of 2
Lecture 34 Using AWR Reports 1 of 9
Lecture 35 Using AWR Reports 2 of 9
Lecture 36 Using AWR Reports 3 of 9
Lecture 37 Using AWR Reports 4 of 9
Lecture 38 Using AWR Reports 5 of 9
Lecture 39 Using AWR Reports 6 of 9
Lecture 40 Using AWR Reports 7 of 9
Lecture 41 Using AWR Reports 8 of 9
Lecture 42 Using AWR Reports 9 of 9
Lecture 43 Using AWR Comparison Reports
Lecture 44 Practice 5 – Using AWR Reports 1 of 6
Lecture 45 Practice 5 – Using AWR Reports 2 of 6
Lecture 46 Practice 5 – Using AWR Reports 3 of 6
Lecture 47 Practice 5 – Using AWR Reports 4 of 6
Lecture 48 Practice 5 – Using AWR Reports 5 of 6
Lecture 49 Practice 5 – Using AWR Reports 6 of 6
Lecture 50 Practice 6 – Using AWR SQL Reports
Lecture 51 Managing AWR Baselines
Lecture 52 Managing AWR Baseline Templates 1 of 2
Lecture 53 Managing AWR Baseline Templates 2 of 2
Lecture 54 Practice 7 – Using AWR Baselines and Baseline Templates
Section 10: Metrics, Event Histograms and Server-generated Alerts
Lecture 55 Metrics and Event Histograms 1 of 2
Lecture 56 Metrics and Event Histograms 2 of 2
Lecture 57 Server-generated Alerts 1 of 2
Lecture 58 Server-generated Alerts 2 of 2
Lecture 59 Practice 8 – Using Server-generated Alerts 1 of 2
Lecture 60 Practice 8 – Using Server-generated Alerts 2 of 2
Lecture 61 Adaptive Thresholds
Section 11: Using Statspack
Lecture 62 Using Statspack 1 of 4
Lecture 63 Using Statspack 2 of 4
Lecture 64 Using Statspack 3 of 4
Lecture 65 Using Statspack 4 of 4
Lecture 66 Practice 9 – Using Statspack 1 of 2
Lecture 67 Practice 9 – Using Statspack 2 of 2
Section 12: Using Automatic Database Diagnostic Monitor (ADDM)
Lecture 68 Using Automatic Database Diagnostic Monitor (ADDM) 1 of 3
Lecture 69 Using Automatic Database Diagnostic Monitor (ADDM) 2 of 3
Lecture 70 Using Automatic Database Diagnostic Monitor (ADDM) 3 of 3
Lecture 71 Using ADDM Comparison Report 1 of 2
Lecture 72 Using ADDM Comparison Report 2 of 2
Lecture 73 Practice 10 – Using Automatic Database Diagnostic Monitor (ADDM) 1 of 2
Lecture 74 Practice 10 – Using Automatic Database Diagnostic Monitor (ADDM) 2 of 2
Section 13: Using Active Session History (ASH)
Lecture 75 Using Active Session History (ASH) 1 of 3
Lecture 76 Using Active Session History (ASH) 2 of 3
Lecture 77 Using Active Session History (ASH) 3 of 3
Lecture 78 Querying ASH 1 of 4
Lecture 79 Querying ASH 2 of 4
Lecture 80 Querying ASH 3 of 4
Lecture 81 Querying ASH 4 of 4
Lecture 82 Practice 11 – Using Active Session History (ASH) 1 of 4
Lecture 83 Practice 11 – Using Active Session History (ASH) 2 of 4
Lecture 84 Practice 11 – Using Active Session History (ASH) 3 of 4
Lecture 85 Practice 11 – Using Active Session History (ASH) 4 of 4
Lecture 86 Practice 12 – Linking ASH to Its Dimension Views 1 of 4
Lecture 87 Practice 12 – Linking ASH to Its Dimension Views 2 of 4
Lecture 88 Practice 12 – Linking ASH to Its Dimension Views 3 of 4
Lecture 89 Practice 12 – Linking ASH to Its Dimension Views 4 of 4
Section 14: Using Database Services
Lecture 90 Introducing Database Services 1 of 4
Lecture 91 Introducing Database Services 2 of 4
Lecture 92 Introducing Database Services 3 of 4
Lecture 93 Introducing Database Services 4 of 4
Lecture 94 Practice 13 – Using Database Service Performance Statistics 1 of 2
Lecture 95 Practice 13 – Using Database Service Performance Statistics 2 of 2
Lecture 96 Using Module Action and Client Identifier 1 of 3
Lecture 97 Using Module Action and Client Identifier 2 of 3
Lecture 98 Using Module Action and Client Identifier 3 of 3
Lecture 99 Practice 14 – Using Module, Action, and Client Identifier Attributes 1 of 4
Lecture 100 Practice 14 – Using Module, Action, and Client Identifier Attributes 2 of 4
Lecture 101 Practice 14 – Using Module, Action, and Client Identifier Attributes 3 of 4
Lecture 102 Practice 14 – Using Module, Action, and Client Identifier Attributes 4 of 4
Section 15: SQL Tracing
Lecture 103 SQL Tracing 1 of 3
Lecture 104 SQL Tracing 2 of 3
Lecture 105 SQL Tracing 3 of 3
Lecture 106 Using tkprof Utility 1 of 2
Lecture 107 Using tkprof Utility 2 of 2
Lecture 108 Practice 15 – Tracing SQL Statements using DBMS_MONITOR 1 of 4
Lecture 109 Practice 15 – Tracing SQL Statements using DBMS_MONITOR 2 of 4
Lecture 110 Practice 15 – Tracing SQL Statements using DBMS_MONITOR 3 of 4
Lecture 111 Practice 15 – Tracing SQL Statements using DBMS_MONITOR 4 of 4
Section 16: Monitoring Database Operations in Real-time
Lecture 112 Monitoring Database Operations in Real-time 1 of 3
Lecture 113 Monitoring Database Operations in Real-time 2 of 3
Lecture 114 Monitoring Database Operations in Real-time 3 of 3
Lecture 115 Practice 16 – Monitoring Database Operations in Real-time 1 of 3
Lecture 116 Practice 16 – Monitoring Database Operations in Real-time 2 of 3
Lecture 117 Practice 16 – Monitoring Database Operations in Real-time 3 of 3
Section 17: Managing the Automated Maintenance Tasks
Lecture 118 Managing the Automated Maintenance Tasks 1 of 2
Lecture 119 Managing the Automated Maintenance Tasks 2 of 2
Lecture 120 Practice 17 – Managing Automated Maintenance Tasks
Section 18: Overview of the Tools Covered So Far
Lecture 121 Overview of the Tools Covered So Far
Section 19: Handling Enqueue Waits
Lecture 122 Handling Enqueue Waits 1 of 3
Lecture 123 Handling Enqueue Waits 2 of 3
Lecture 124 Handling Enqueue Waits 3 of 3
Lecture 125 Practice 18 – Handling Enqueue Waits 1 of 3
Lecture 126 Practice 18 – Handling Enqueue Waits 2 of 3
Lecture 127 Practice 18 – Handling Enqueue Waits 3 of 3
Section 20: Handling Latches and Mutexes
Lecture 128 Introducing Latches and Mutex 1 of 2
Lecture 129 Introducing Latches and Mutex 2 of 2
Lecture 130 Handling Latch and Mutex Contention 1 of 2
Lecture 131 Handling Latch and Mutex Contention 2 of 2
Lecture 132 Handling Cache Buffer Chain (CBC) Latch 1 of 2
Lecture 133 Handling Cache Buffer Chain (CBC) Latch 2 of 2
Lecture 134 Handling Other Latch Types 1 of 2
Lecture 135 Handling Other Latch Types 2 of 2
Lecture 136 Practice 19 – Handling Latch and Mutex Contention 1 of 4
Lecture 137 Practice 19 – Handling Latch and Mutex Contention 2 of 4
Lecture 138 Practice 19 – Handling Latch and Mutex Contention 3 of 4
Lecture 139 Practice 19 – Handling Latch and Mutex Contention 4 of 4
Section 21: Tuning the Shared Pool
Lecture 140 Tuning the Shared Pool 1 of 4
Lecture 141 Tuning the Shared Pool 2 of 4
Lecture 142 Tuning the Shared Pool 3 of 4
Lecture 143 Tuning the Shared Pool 4 of 4
Lecture 144 Sizing the Shared Pool
Lecture 145 Practice 20 – Tuning the Shared Pool 1 of 2
Lecture 146 Practice 20 – Tuning the Shared Pool 2 of 2
Lecture 147 Caching Session Cursors 1 of 2
Lecture 148 Caching Session Cursors 2 of 2
Lecture 149 Practice 21 – Caching Session Cursors 1 of 2
Lecture 150 Practice 21 – Caching Session Cursors 2 of 2
Lecture 151 Managing Server Result Cache 1 of 2
Lecture 152 Managing Server Result Cache 2 of 2
Lecture 153 Practice 22 – Managing Server Result Cache 1 of 2
Lecture 154 Practice 22 – Managing Server Result Cache 2 of 2
Section 22: Tuning the Buffer Cache
Lecture 155 Tuning the Buffer Cache 1 of 5
Lecture 156 Tuning the Buffer Cache 2 of 5
Lecture 157 Tuning the Buffer Cache 3 of 5
Lecture 158 Tuning the Buffer Cache 4 of 5
Lecture 159 Tuning the Buffer Cache 5 of 5
Lecture 160 Practice 23 – Tuning the Buffer Cache 1 of 3
Lecture 161 Practice 23 – Tuning the Buffer Cache 2 of 3
Lecture 162 Practice 23 – Tuning the Buffer Cache 3 of 3
Lecture 163 Using Smart Flash Cache 1 of 3
Lecture 164 Using Smart Flash Cache 2 of 3
Lecture 165 Using Smart Flash Cache 3 of 3
Lecture 166 Practice 24 – Using Smart Flash Cache 1 of 2
Lecture 167 Practice 24 – Using Smart Flash Cache 2 of 2
Section 23: Tuning the PGA
Lecture 168 Tuning the PGA 1 of 6
Lecture 169 Tuning the PGA 2 of 6
Lecture 170 Tuning the PGA 3 of 6
Lecture 171 Tuning the PGA 4 of 6
Lecture 172 Tuning the PGA 5 of 6
Lecture 173 Tuning the PGA 6 of 6
Lecture 174 Practice 25 – Tuning the PGA 1 of 3
Lecture 175 Practice 25 – Tuning the PGA 2 of 3
Lecture 176 Practice 25 – Tuning the PGA 3 of 3
Section 24: Tuning the Redo Path
Lecture 177 Tuning the Redo Path 1 of 4
Lecture 178 Tuning the Redo Path 2 of 4
Lecture 179 Tuning the Redo Path 3 of 4
Lecture 180 Tuning the Redo Path 4 of 4
Lecture 181 Practice 26 – Tuning the Redo Path
Section 25: Detecting CPU Bottlenecks
Lecture 182 Detecting CPU Bottlenecks 1 of 2
Lecture 183 Detecting CPU Bottlenecks 2 of 2
Lecture 184 Practice 27 – Detecting CPU Bottlenecks 1 of 2
Lecture 185 Practice 27 – Detecting CPU Bottlenecks 2 of 2
Section 26: Tuning Disk IO Operations in Oracle Database
Lecture 186 Tuning Disk IO Operations in Oracle Database 1 of 8
Lecture 187 Tuning Disk IO Operations in Oracle Database 2 of 8
Lecture 188 Tuning Disk IO Operations in Oracle Database 3 of 8
Lecture 189 Tuning Disk IO Operations in Oracle Database 4 of 8
Lecture 190 Tuning Disk IO Operations in Oracle Database 5 of 8
Lecture 191 Tuning Disk IO Operations in Oracle Database 6 of 8
Lecture 192 Tuning Disk IO Operations in Oracle Database 7 of 8
Lecture 193 Tuning Disk IO Operations in Oracle Database 8 of 8
Lecture 194 Practice 28 – Tuning Disk IO Operations in Oracle Database 1 of 2
Lecture 195 Practice 28 – Tuning Disk IO Operations in Oracle Database 2 of 2
Section 27: Maintaining In-production Indexes for Performance
Lecture 196 Maintaining In-production Indexes for Performance 1 of 5
Lecture 197 Maintaining In-production Indexes for Performance 2 of 5
Lecture 198 Maintaining In-production Indexes for Performance 3 of 5
Lecture 199 Maintaining In-production Indexes for Performance 4 of 5
Lecture 200 Maintaining In-production Indexes for Performance 5 of 5
Lecture 201 Practice 29 – Performing Index Defragmentation 1 of 2
Lecture 202 Practice 29 – Performing Index Defragmentation 2 of 2
Section 28: Handling Row Migration and Row Chaining
Lecture 203 Introducing Row Migration and Row Chaining 1 of 2
Lecture 204 Introducing Row Migration and Row Chaining 2 of 2
Lecture 205 Handling Row Migration and Row Chaining 1 of 3
Lecture 206 Handling Row Migration and Row Chaining 2 of 3
Lecture 207 Handling Row Migration and Row Chaining 3 of 3
Lecture 208 Practice 30 – Handling Row Migration and Row Chaining 1 of 3
Lecture 209 Practice 30 – Handling Row Migration and Row Chaining 2 of 3
Lecture 210 Practice 30 – Handling Row Migration and Row Chaining 3 of 3
Section 29: Diagnosing Table Fragmentation
Lecture 211 Diagnosing Table Fragmentation 1 of 2
Lecture 212 Diagnosing Table Fragmentation 2 of 2
Lecture 213 Practice 31 – Diagnosing Table Fragmentation
Section 30: Using Table Compression
Lecture 214 Using Table Compression 1 of 3
Lecture 215 Using Table Compression 2 of 3
Lecture 216 Using Table Compression 3 of 3
Lecture 217 Practice 32 – Using Table Compression 1 of 2
Lecture 218 Practice 32 – Using Table Compression 2 of 2
Section 31: Introducing In-Memory Column Store
Lecture 219 Introducing In-Memory Column Store 1 of 3
Lecture 220 Introducing In-Memory Column Store 2 of 3
Lecture 221 Introducing In-Memory Column Store 3 of 3
Lecture 222 Practice 33 – Introducing In-Memory Column Store
Section 32: Optimizing Database Connection
Lecture 223 Optimizing Database Connection 1 of 6
Lecture 224 Optimizing Database Connection 2 of 6
Lecture 225 Optimizing Database Connection 3 of 6
Lecture 226 Optimizing Database Connection 4 of 6
Lecture 227 Optimizing Database Connection 5 of 6
Lecture 228 Optimizing Database Connection 6 of 6
Lecture 229 Practice 34 – Optimizing Database Connection
Section 33: Monitoring Oracle Database Performance using EM Database Express
Lecture 230 Monitoring Oracle Database Performance using EM Database Express
Lecture 231 Using Oracle EM Express for Performance Tuning – Demo 1 of 5
Lecture 232 Using Oracle EM Express for Performance Tuning – Demo 2 of 5
Lecture 233 Using Oracle EM Express for Performance Tuning – Demo 3 of 5
Lecture 234 Using Oracle EM Express for Performance Tuning – Demo 4 of 5
Lecture 235 Using Oracle EM Express for Performance Tuning – Demo 5 of 5
Section 34: Monitoring OS Performance using Linux Utilities
Lecture 236 Monitoring OS Performance using Linux Utilities 1 of 2
Lecture 237 Monitoring OS Performance using Linux Utilities 2 of 2
Lecture 238 Practice 35 – Monitoring OS Performance using Linux Utilities 1 of 5
Lecture 239 Practice 35 – Monitoring OS Performance using Linux Utilities 2 of 5
Lecture 240 Practice 35 – Monitoring OS Performance using Linux Utilities 3 of 5
Lecture 241 Practice 35 – Monitoring OS Performance using Linux Utilities 4 of 5
Lecture 242 Practice 35 – Monitoring OS Performance using Linux Utilities 5 of 5
Lecture 243 Using OSWatcher Black Box 1 of 3
Lecture 244 Using OSWatcher Black Box 2 of 3
Lecture 245 Using OSWatcher Black Box 3 of 3
Lecture 246 Practice 36 – Using OSWatcher Black Box 1 of 2
Lecture 247 Practice 36 – Using OSWatcher Black Box 2 of 2
Section 35: Using SQL Performance Analyzer
Lecture 248 Using SQL Performance Analyzer 1 of 3
Lecture 249 Using SQL Performance Analyzer 2 of 3
Lecture 250 Using SQL Performance Analyzer 3 of 3
Lecture 251 Practice 37 – Using SQL Performance Analyzer 1 of 2
Lecture 252 Practice 37 – Using SQL Performance Analyzer 2 of 2
Section 36: Using Database Replay
Lecture 253 Using Database Replay 1 of 4
Lecture 254 Using Database Replay 2 of 4
Lecture 255 Using Database Replay 3 of 4
Lecture 256 Using Database Replay 4 of 4
Lecture 257 Practice 38 – Using Database Replay 1 of 7
Lecture 258 Practice 38 – Using Database Replay 2 of 7
Lecture 259 Practice 38 – Using Database Replay 3 of 7
Lecture 260 Practice 38 – Using Database Replay 4 of 7
Lecture 261 Practice 38 – Using Database Replay 5 of 7
Lecture 262 Practice 38 – Using Database Replay 6 of 7
Lecture 263 Practice 38 – Using Database Replay 7 of 7
Section 37: Course Documents
Lecture 264 Course Documents and Files
Oracle DBAs
Homepage

https://www.udemy.com/course/oracle-database-performance-tuning/

DDOWNLOAD