Home / Course catalog / Interview Crash Course -Performance Tuning


Get this course

Tuning

Interview Crash Course -Performance Tuning


Description

Intended Audience :- IF you already have, "Oracle Performance Tuning" knowledge but want to refresh your knowledge fast and start giving interviews with confidence and also perform your job with more confidence.

Tuning Topics Covered: -

1. Tables

2. Indexes

3. Explain Plan

4. Joins

5. Hints

6. OEM

7. Wait Events

8. AWR

9. ASH

10.ADDM

11. Misc SQL Tuning Topics

Mode of Course:- 

1. Quizes with multiple Choices, 

2. Match the following

3. Order the Concepts for a particular Tuning Concept

4.Real World Scenario (Problem/Possible Issues/Approaches/Solutions)

4. Cheat Sheets 

5. Recap on Tuning Key Concepts  


Content
  • Introduction
  • Oracle Tuning Introduction (36 mins)
  • TroubleShooting - Concepts
  • Indexes - Tuning
  • Index Concepts
  • Index Types -Test (30 +)
  • Index Internals -Concepts
  • Index Internals-Test (30 +)
  • Index Scan - Concepts
  • Index Scan - Test (16 +)
  • Table - Performance Tuning
  • Table -Concepts
  • Table Statistics - Test (18+)
  • Full Table Scans -Concepts
  • Full Table Scans -Test (10+)
  • Explain Plan
  • Explain Plan Concepts
  • Explain Plan - Test (36+)
  • Joins - Concepts
  • Joins - Test (13+)
  • Hints - Concepts
  • Hints -Test (25+)
  • SQL Tuning - Concepts
  • SQL Tuning - Misc Topics -Test (16+)
  • AWR
  • OEM(5+)
  • Wait Events - Concepts
  • Wait Events - Test (14+)
  • AWR -Concepts
  • AWR -Test (45+)
  • AWR - RealTimeScenario -1
  • AWR-Instance Efficiency Percentage -Hit Ratios
  • ASH - Concepts
  • ASH -Test (18+)
  • ADDM - Test (7)
  • Misc topics
  • Real World Scenario -SQL Tuning -1
  • Real World Scenario - SQL Tuning -2
  • Real World Scenario - SQL Tuning -3
  • Real World Scenario - SQL Tuning -4
  • Real World Scenario SQL Tuning - 5
  • Real World Scenario SQL Tuning - 6
  • Real World Scenario SQL Tuning - 7
  • Real World Scenario SQL Tuning -8
  • Real World Scenario SQL Tuning - 9
  • Real world Scenario SQL Tuning - 10
  • Real World Scenario SQL Tuning -11
  • Real World Scenario SQL Tuning - 12
  • Real World Scenario SQL Tuning - 13
  • Real World Scenarios SQL Tuning -14
  • Real World Scenario - DBA -15
  • Real World Scenario - DBA -16
  • Real World Scenario - DBA -17
  • Real World Scenario - DBA -18
  • Real world Scenario - AWR - 19
  • Real World Scenario SQL Tuning - 20
  • Real World Scenario  SQL Tuning  -21
  • Real World Scenario SQL Tuning -22
  • Real World Scenario SQL Tuning -23
  • Real World Scenario SQL Tuning -24
  • Real World Scenario - AWR -25
  • Real World Scenario - ASH -26
  • Real World Scenario - ASH-28
  • Real World Scenario - ASH-29
  • Real World Scenario - ADDM - 30
  • Real World Scenario - AWR - 31
  • Cheat sheets
  •  Bad SQL Performance -Cheat Sheet
  • Index Types - Cheat Sheet
  • Table and Index Scans - Cheat Sheet
  • Joins- Cheat Sheet
  • Hints-CheatSheet
  • AWR - Wait Events - Cheat Sheet
  • Mock Test
  • Mock Test -1
  • Mock Test-2
  • References
  • Sample Files - AWR Compare Period Report
  • MISC
Completion rules
  • All units must be completed
Back