Oracle DBA Performance Tuning
Created by Parth Panjabi, Last Updated 05-Sep-2019, Language:English
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
Preview00: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.