Oracle DBA Performance Tuning
Simply Easy Learning
Created by Parth Panjabi, Last Updated 05-Sep-2019, Language:English
Description
In this online training , you will learn Oracle DB 11g Peformance Tuning which includes understanding of Oracle Database Archirecture,Performance Tuning Tools e.g OEM,AWR,ADDM and ASH,Oracle Optimizer,Indexing,Partitions,memory tuning.
Audience
This course is suitable for any student or working professional who wants to set the career as Oracle Database Administrator or who already working as Oracle DBA can learn performance tuning in detail.
Course Content
-
Oracle DB Architecture Tuning Centric
6 Lectures
01:09:58
-
Software Functionality
Preview00:09:58 -
OS Dependencies
00:11:55 -
Application and Networking Architecture
00:08:31 -
Oracle Database Architecture
00:16:37 -
Memory Dependencies
00:13:43 -
Storage Dependencies
00:09:14
-
-
Performance Tuning Tools
8 Lectures
01:53:45
-
Performance Tuning Tools
00:30:35 -
Tracing SQL Execution
00:23:14 -
tkprof for Trace Analysis
00:12:55 -
Autotrace In SQL
Preview00:06:44 -
V$ Dynamic Performance Views
00:09:47 -
Oracle Enterprise Manager (OEM)
00:07:23 -
AWR, ADDM and ASH Reports
00:15:35 -
SQL Tuning Advisor & Baselines
00:07:32
-
-
Oracle Optimizer
8 Lectures
01:32:53
-
Basics of Optimizer
00:05:06 -
Understanding Behaviour
00:10:44 -
Histograms and Bind Picking
00:20:43 -
Access Paths
00:18:26 -
Interpreting JOINS
00:04:58 -
Optimizer Statistics
00:11:09 -
Oracle Optimizer Hints
00:08:03 -
Manage Optimizer
00:13:44
-
-
SQL Tuning with Activities-1
4 Lectures
00:30:03
-
Thumb Rules
00:13:48 -
Possible SQL Issues
00:01:11 -
SQL Tuning Methods and Tools
00:13:02 -
Pro Active & Reactive SQL Tuning
Preview00:02:02
-
-
SQL Tuning with Activities-2
6 Lectures
00:40:43
-
Creating SQL Tuning Sets
00:11:29 -
SQL Plan Baselines
00:09:53 -
Tuning JOINS
00:08:53 -
Sorting and Grouping Activities
00:03:41 -
PL/SQL Tuning Notes
00:03:46 -
Parallelism in SQL
00:03:01
-
-
Real Time Data Loading and Monitoring
1 Lectures
00:35:44
-
Real Time Data Loading and Monitoring
00:35:44
-
-
Real Time – AWR Report Analysis
1 Lectures
00:20:49
-
Real Time – AWR Report Analysis
00:20:49
-
-
Reports and Analysis
3 Lectures
00:31:51
-
AWR Reports and Baselines
00:10:14 -
ADDM Reports
Preview00:10:21 -
ASH Report
00:11:16
-
-
Database Storage Objects
5 Lectures
01:42:23
-
Storage Options
00:27:41 -
Oracle Partitioning
00:18:11 -
Indexes Overview and B-Tree Index
00:38:04 -
BitMap Indexes & Examples
00:11:58 -
Index Organized Tables and Examples
00:06:29
-
-
Advisories
1 Lectures
00:39:15
-
Advisories
00:39:15
-
-
Instance/Memory Real Time Tuning
7 Lectures
01:25:11
-
Shared Pool Tuning
00:11:19 -
Diagnostic Tools for Tuning the Shared Pool
00:17:34 -
Memory Real Time Tuning Cursors
Preview00:08:32 -
Parses and Data Dictionary
00:12:15 -
Result Cache
00:08:01 -
Buffer Cache Tuning
00:16:42 -
PGA Tuning and Sort Area
00:10:48
-
-
I/O Tuning
2 Lectures
00:16:13
-
Oracle I/O Architecture
00:03:20 -
I/O TUNING – Options
00:12:53
-
-
Best Architectural Practices
1 Lectures
00:27:41
-
Best Architectural Practices
00:27:41
-
Parth Panjabi
Parth Panjabi holds a B.E. in Informatiom Technology. He holds Oracle Certification like OCA,OCP 11g. Parth has more than 7 years of experience in IT and Corporate training. He has delivered corporate training where he taught Oracle Database Administrator 12c,11g,10g and SQL,PL/SQL.