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