Oracle Performance Tuning
-
Invisible indexes
- 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 min...
- 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 ...
- 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 ...
- Table High Water Mark ( 12 mins)
- Fragmentation issues - Tuning (13 mins)
- Data Loading - Partition Exchange Loading - PEL ( ...
- 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 ...
- 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 Pl...
- 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...
- FTS -Various Index Scans - slides
- Nested Loop , Sort Merge , Hash Join Methods (14 ...
- 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 ...
- How to Tune When only Explain Plan is Given (No Qu...
- 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 min...
- Lock Contention Issue - AWR Report Analysys (7 min...
- 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 m...
- 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)
- ORACLE 12C - TUNING NEW FEATURES
- Invisible Indexes What, why ,When, How Factors - (...
- 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 Dat...
- Histogram - Types (14 mins)
- Oracle 12c New Features (Additional Reference Info...
- 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)
- Oracle 19c New Features
- Oracle 19c New Features ( 3 mins)
- Meta Link Benefits ( 3 mins)
- My Oracle Support - Registration (8 mins)
- 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
- Demo Videos
- 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
