Home / Course catalog / Oracle Performance Tuning

Tuning

Oracle Performance Tuning


Description
Oracle Performance Tuning Tutorial:-
- 30 hour duration Videos (ONE month Video VIEW access)
- PDF material for each topic (can be downloaded)
- Quizes : 100+ Questions

info@dbvidya.com
+91 991 2323 000
Content
  • Oracle Performance Tuning - Introduction
  • Oracle SQL Tuning Introduction (36 mins)
  • SQL Tuning Introduction - Presentation slides
  • My Oracle Support / Metalink (6 mins)
  • Quiz - Oracle Performance Tuning -Introduction
  • ORACLE ARCHITECTURE CONCEPTS
  • Oracle Architecture Concepts (51 mins)
  • Oracle Database Startup - Discussion Video ( 4 mins)
  • Architecture - Doubts (23 mins)
  • Oracle Architecture Concepts (51 mins)
  • Quiz-Oracle Architecture
  • FINDING TOP PROBLEMS
  • Finding Top Problem SQLs ( mins)
  • Finding the Problem SQLs - slides
  • Quiz -Finding Top SQLs
  • Quiz - Finding Problem SQLs_2
  • TABLE MANAGEMENT WRT TUNING
  • Tables Role in Tuning ( 28 mins)
  • Table Cache - Feature (11 mins)
  • Table - Estimating Size ( 11 mins)
  • Global Temporary Tables - Tuning (14 mins)
  • Tables and Tuning - slides
  • Quiz- Tables
  • Table - Partitioning
  • Table - Partitioning ( 35 mins)
  • Tables Partitioning Introduction- slides
  • Table Partitioning - Maintenance ( 13 mins)
  • Partitioning Maintenance - Slides
  • Partitioning - Indexes Types (17 mins)
  • Partitioning Indexes- slides
  • Quiz - Table Partitions
  • INDEXES - TUNING
  • B*Tree Index and Bitmap Index ( 33 mins)
  • Full Table Scan(FTS) vs Index Scan (8 mins)
  • Reverse Key Index (9 mins)
  • Function Based Index - Index Best Practices ( 35 mins)
  • Cardinality -Bitmap Index - (3 mins)
  • Indexes Tuning - slides
  • Quiz - Indexes
  • Memory Tuning
  • Memory Tuning ( 56 mins)
  • Memory Tuning - Parameters ( 29 mins)
  • Memory Tuning - Slides
  • Quiz - Memory Tuning
  • STORAGE PARAMETER TUNING
  • Oracle Physical Logical Structure ( 1 mins)
  • Data Dictionary Views and Table Analyzing options (5 mins)
  • Table High Water Mark ( 12 mins)
  • Fragmentation issues - Tuning (13 mins)
  • Data Loading - Partition Exchange Loading - PEL ( 3 mins)
  • Row Chaining and Migration (20 mins)
  • Storage Parameter Tuning - slides
  • Quiz - Storage Parameter Tuning
  • SQL TUNING
  • Writing Queries Efficiently ( 35 mins)
  • Bulk Operations (6 mins)
  • Writing Queries Efficiently - slides
  • Oracle Statement Processing Steps (12 mins)
  • Statement Processing - slides
  • WITH Clause VS GTT(Global Temporary Tables) -( 15 mins)
  • Quiz - SQL Tuning
  • EXPLAIN PLAN
  • Auto Trace ( 4 mins)
  • Explain Plan Interpretation (28 mins)
  • Explain Plan - Sql Developer (4 mins)
  • Explain Plan - slides
  • Filter Predicate Vs Access Predicate in Explain Plan ( 5mins)
  • Explain Plan - Examples (19 mins)
  • Explain Plan - Examples (19 mins)
  • 7 Rules -Index usage wrt Comparision Operators
  • Quiz - Explain Plan
  • EXPLAIN PLAN - ADDITIONAL INFORMATION
  • Equal SQL is not Always Equal ( 10 mins)
  • How to Compare Execution Plans ( 5 mins)
  • Oracle SQL Tuning Tips - Reference URL
  • Tune Code which cannot be Edited ( 5 mins)
  • Pin Old Execution Plan to Memory (10 mins)
  • EXPLAIN PLAN - TABLE ACCESS TYPES
  • Table Access - Scans FTS, Various Index scan Types (26 mins)
  • FTS -Various Index Scans - slides
  • Nested Loop , Sort Merge , Hash Join Methods (14 mins)
  • Join Vs Subquery ( 9 mins)
  • Subquery VS Correlated Subquery in SQL
  • Explain Plan - Doubts Discussion ( 22 mins)
  • Real Time Query -Discussions ( 35 mins)
  • Nested Loop Join -Hash Join-Merg sort Join- slides
  • Explain Plan -Cardinality and Bytes Columns -FTS and Index Scan - (19 mins)
  • How to Tune When only Explain Plan is Given (No Query is Given)-( 12 mins)
  • Quiz - Table Access Types
  • HINTS FOR TUNING
  • Oracle Hints ( 63 mins)
  • First_rows Hint - Detail ( 3 mins)
  • Hints - slides
  • Quiz - Oracle Hints
  • PROCEDURE/PACKAGE /SQL SCRIPT - TUNING
  • TKProf ( 34 mins)
  • TKProf-DML (21 mins)
  • Tuning - PLSQL ( 7 mins)
  • Tkprof Utility - Discussion ( 12 mins)
  • Tkprof - slides
  • Quiz-TKprof Utility and AutoTrace
  • SORTING - TUNING
  • Sort Operations Tuning (18 mins)
  • Sorting - slides
  • SQL Tuning Tips ( 3 mins)
  • Quiz - Sorting
  • OEM - ORACLE ENTERPRISE MANAGER
  • OEM- SQL Tuning (Brief) (13 mins)
  • OEM SQL Tuning - ASH ,AWR,ADDM (22 mins)
  • Oracle Enterprise Manager - slides
  • ASH vs AWR vs ADDM ( 5 mins)
  • AWR vs ASH Report - Presentation Slides
  • Quiz - OEM (Oracle Enterprise Manager)
  • AWR - AUTOMATIC WORKLOAD REPOSITORY
  • Oracle Wait Events (50 mins)
  • Page In-Page Out and Buffer Busy Waits(12 mins)
  • Wait Events - slides
  • AWR Report Interpretation -Theory (26 mins)
  • AWR Interpretation - slides
  • AWR Report - Real time Project ( 38 mins)
  • AWR Report Generation ( 11 mins)
  • Understanding AWR - Additional Information (44 mins)
  • Lock Contention Issue - AWR Report Analysys (7 mins)
  • Soft Parse Issue - AWR Report Analysys - (7 mins)
  • AWR ADDM - Report from Learner (27 mins)
  • AWR Vs ASH More Differences ( 6 mins)
  • AWR vs ASH Report - Presentation Slides
  • ASH report.pdf - Sample
  • AWR report.pdf - Sample
  • Quiz -AWR ADDM ASH
  • DATA LOADS - TUNING
  • Tuning - Data Loads ( 34 mins)
  • Data Loads - slides
  • Quiz- Dataloads
  • SPM OUTLINES PROFILES
  • SPM Outlines Profiles (8 mins)
  • Flow Chart on Hints vs Statistics vs profiles (5 mins)
  • SQL Tuning Advisor (STA) in SQL Developer ( 9 mins)  sample
  • SPM- SQL Plan Management - slides
  • Quiz- SPM Profiles Baselines
  • SQL TUNING SCENARIOS AND APPROACHES
  • SQL Tuning Scenarios and Approaches(18 mins)
  • ORACLE 12C - TUNING NEW FEATURES
  • Invisible Indexes What, why ,When, How Factors - (20 mins)
  • Unusable Indexes vs Invisible Indexes (6 mins)
  • dbms_xplan for Explain Plan (22 mins)
  • SQL execution plan A-ROWS vs. E-ROWS (4 mins)
  • Adaptive Query Optimization ( 10 mins)
  • Dynamic Statistics ( 14 mins)
  • Bulk Loads-Online Stats Gathering ( 10 mins)
  • Histograms - What , Why , When, How and Skewed Data) (12 mins)
  • Histogram - Types (14 mins)
  • Oracle 12c New Features (Additional Reference Information)
  • Oracle 12c Tuning Features- slides
  • OEM 12c Overview (13 mins)
  • Quiz-Oracle 12c Tuning
  • REFERENCE MATERIAL (OPTIONAL VIDEOS)
  • Oracle 18c - Performance Features
  • Scalable Sequences - Oracle 18c - (12 mins) sample
  • Oracle 19c New Features
  • Oracle 19c New Features ( 3 mins)  sample
  • Meta Link Benefits ( 3 mins)
  • My Oracle Support - Registration (8 mins)
  • Oracle Performance -Additional Reference Information
  • Tuning Query with Many Joins and deciding Join Order
  • Result Cache -Approximate Query Processing Feature -In-Memory wrt Tuning
  • Oracle Performance Features - From 7.x to 19c
  • Testimonials/Feedback/Recommendations
  • Testimonials -1 sample
  • Testimonials -2 sample
  • Testimonials - 3 sample
  • Testimonials - 4 sample
  • Testimonials - 5 sample
  • Testimonials - 6 sample
  • Testimonials - 7 sample
  • Testimonials - 8 sample
  • Testimonials - 9  sample
  • Testimonials - 10 sample
  • Testimonials - 11 sample
  • Testimonials - 12 sample
  • Trainer /Faculty Details
  • Click for - Trainer Profile  sample
  • Demo Videos
  • Oracle DBA Performance Tuning DEMO Video ( 17 mins) sample
  • Oracle Index Types- Excerpt sample
  • Invisible indexes  sample
  • Unusable vs Invisible Indexes sample
  • Full table Access and Index Scan -Part 1 sample
  • Full table Access and Index Scan -Part 2 sample
  • Oracle Explain plan ( excerpt) sample
  • Estimated vs actual rows sample
  • Oracle Alert Log File Contents ( 4 mins) sample
  • TKProf Utility (Excerpt) sample
  • Oracle Wait Events sample
  • Lock Contention Issue - AWR Report Analysys (7 mins) sample
  • How to resolve deadlocks in Oracle (2 mins ) sample
  • Histograms sample
  • Oracle Tuning -Third Party Tools - ( 4 mins) sample
  • Pin Old Execution Plan to Memory using sqltrpt.sql (6 mins) sample
  • Check Current Running SQLs - OEM 12c (5 mins) sample
  • Why is SQL Running Slow  sample
  • Function Based Index - Performance ( 6 mins) sample
  • Oracle Table Partitioning ( 5 mins) sample
  • Materialized Views wrt Performance -Use Case (14 mins)  sample
  • Virtual Columns - Performance (10 mins)  sample
  • Cardinality -Bitmap Index - (3 mins) sample
  • Feedback / Suggestions
  • Feedback on Course
  • FAQ
  • Oracle Performance Tuning - Interview Questions  sample
Completion rules
  • All units must be completed