1. Introduction FREE CHAPTER

• Introducing the Course

2. Practice 1 - Preparing Practice Environment

• Practice 1 - Preparing Practice Environment 1 of 7
• Practice 1 - Preparing Practice Environment 2 of 7
• Practice 1 - Preparing Practice Environment 3 of 7
• Practice 1 - Preparing Practice Environment 4 of 7
• Practice 1 - Preparing Practice Environment 5 of 7
• Practice 1 - Preparing Practice Environment 6 of 7
• Practice 1 - Preparing Practice Environment 7 of 7

3. Introduction to Oracle Database Performance Tuning

• Introduction to Oracle Database Performance Tuning 1 of 3
• Introduction to Oracle Database Performance Tuning 2 of 3
• Introduction to Oracle Database Performance Tuning 3 of 3

4. About Performance Tuning in IT Systems

• About Performance Tuning in IT Systems 1 of 2
• About Performance Tuning in IT Systems 2 of 2

5. Introduction to Oracle Database Performance Tuning Tools

• Introduction to Oracle Database Performance Tuning Tools

6. Using Time Model

• Using Time Model 1 of 3
• Using Time Model 2 of 3
• Using Time Model 3 of 3
• Practice 2 -Using Time Model 1 of 2
• Practice 2 -Using Time Model 2 of 2

7. Using Instance Activity Statistics

• Using Instance Activity Statistics 1 of 2
• Using Instance Activity Statistics 2 of 2

8. Wait Events

• Wait Events 1 of 3
• Wait Events 2 of 3
• Wait Events 3 of 3
• Practice 3 - Viewing Instance Activity and Wait Events 1 of 3
• Practice 3 - Viewing Instance Activity and Wait Events 2 of 3
• Practice 3 - Viewing Instance Activity and Wait Events 3 of 3

9. Using AWR

• Overview of Automatic Workload Repository (AWR)
• Managing AWR Snapshots 1 of 3
• Managing AWR Snapshots 2 of 3
• Managing AWR Snapshots 3 of 3
• Practice 4 - Managing Automatic Workload Repository (AWR) 1 of 2
• Practice 4 - Managing Automatic Workload Repository (AWR) 2 of 2
• Using AWR Reports 1 of 9
• Using AWR Reports 2 of 9
• Using AWR Reports 3 of 9
• Using AWR Reports 4 of 9
• Using AWR Reports 5 of 9
• Using AWR Reports 6 of 9
• Using AWR Reports 7 of 9
• Using AWR Reports 8 of 9
• Using AWR Reports 9 of 9
• Using AWR Comparison Reports
• Practice 5 - Using AWR Reports 1 of 6
• Practice 5 - Using AWR Reports 2 of 6
• Practice 5 - Using AWR Reports 3 of 6
• Practice 5 - Using AWR Reports 4 of 6
• Practice 5 - Using AWR Reports 5 of 6
• Practice 5 - Using AWR Reports 6 of 6
• Practice 6 - Using AWR SQL Reports
• Managing AWR Baselines
• Managing AWR Baseline Templates 1 of 2
• Managing AWR Baseline Templates 2 of 2
• Practice 7 - Using AWR Baselines and Baseline Templates

10. Metrics, Event Histograms, and Server-Generated Alerts

• Metrics and Event Histograms 1 of 2
• Metrics and Event Histograms 2 of 2
• Server-Generated Alerts 1 of 2
• Server-Generated Alerts 2 of 2
• Practice 8 - Using Server-Generated Alerts 1 of 2
• Practice 8 - Using Server-Generated Alerts 2 of 2
• Adaptive Thresholds

11. Using Statspack

• Using Statspack 1 of 4
• Using Statspack 2 of 4
• Using Statspack 3 of 4
• Using Statspack 4 of 4
• Practice 9 - Using Statspack 1 of 2
• Practice 9 - Using Statspack 2 of 2

12. Using Automatic Database Diagnostic Monitor (ADDM)

• Using Automatic Database Diagnostic Monitor (ADDM) 1 of 3
• Using Automatic Database Diagnostic Monitor (ADDM) 2 of 3
• Using Automatic Database Diagnostic Monitor (ADDM) 3 of 3
• Using ADDM Comparison Report 1 of 2
• Using ADDM Comparison Report 2 of 2
• Practice 10 - Using Automatic Database Diagnostic Monitor (ADDM) 1 of 2
• Practice 10 - Using Automatic Database Diagnostic Monitor (ADDM) 2 of 2

13. Using Active Session History (ASH)

• Using Active Session History (ASH) 1 of 3
• Using Active Session History (ASH) 2 of 3
• Using Active Session History (ASH) 3 of 3
• Querying ASH 1 of 4
• Querying ASH 2 of 4
• Querying ASH 3 of 4
• Querying ASH 4 of 4
• Practice 11 - Using Active Session History (ASH) 1 of 4
• Practice 11 - Using Active Session History (ASH) 2 of 4
• Practice 11 - Using Active Session History (ASH) 3 of 4
• Practice 11 - Using Active Session History (ASH) 4 of 4
• Practice 12 - Linking ASH to Its Dimension Views 1 of 4
• Practice 12 - Linking ASH to Its Dimension Views 2 of 4
• Practice 12 - Linking ASH to Its Dimension Views 3 of 4
• Practice 12 - Linking ASH to Its Dimension Views 4 of 4

14. Using Database Services

• Introducing Database Services 1 of 4
• Introducing Database Services 2 of 4
• Introducing Database Services 3 of 4
• Introducing Database Services 4 of 4
• Practice 13 - Using Database Service Performance Statistics 1 of 2
• Practice 13 - Using Database Service Performance Statistics 2 of 2
• Using Module Action and Client Identifier 1 of 3
• Using Module Action and Client Identifier 2 of 3
• Using Module Action and Client Identifier 3 of 3
• Practice 14 - Using Module, Action, and Client Identifier Attributes 1 of 4
• Practice 14 - Using Module, Action, and Client Identifier Attributes 2 of 4
• Practice 14 - Using Module, Action, and Client Identifier Attributes 3 of 4
• Practice 14 - Using Module, Action, and Client Identifier Attributes 4 of 4

15. SQL Tracing

• SQL Tracing 1 of 3
• SQL Tracing 2 of 3
• SQL Tracing 3 of 3
• Using tkprof Utility 1 of 2
• Using tkprof Utility 2 of 2
• Practice 15 - Tracing SQL Statements Using DBMS_MONITOR 1 of 4
• Practice 15 - Tracing SQL Statements Using DBMS_MONITOR 2 of 4
• Practice 15 - Tracing SQL Statements Using DBMS_MONITOR 3 of 4
• Practice 15 - Tracing SQL Statements Using DBMS_MONITOR 4 of 4

16. Monitoring Database Operations in Real Time

• Monitoring Database Operations in Real Time 1 of 3
• Monitoring Database Operations in Real Time 2 of 3
• Monitoring Database Operations in Real Time 3 of 3
• Practice 16 - Monitoring Database Operations in Real Time 1 of 3
• Practice 16 - Monitoring Database Operations in Real Time 2 of 3
• Practice 16 - Monitoring Database Operations in Real Time 3 of 3

17. Managing the Automated Maintenance Tasks

• Managing the Automated Maintenance Tasks 1 of 2
• Managing the Automated Maintenance Tasks 2 of 2
• Practice 17 - Managing Automated Maintenance Tasks

18. Overview of the Tools Covered So Far

• Overview of the Tools Covered So Far

19. Handling Enqueue Waits

• Handling Enqueue Waits 1 of 3
• Handling Enqueue Waits 2 of 3
• Handling Enqueue Waits 3 of 3
• Practice 18 - Handling Enqueue Waits 1 of 3
• Practice 18 - Handling Enqueue Waits 2 of 3
• Practice 18 - Handling Enqueue Waits 3 of 3

20. Handling Latches and Mutexes

• Introducing Latches and Mutex 1 of 2
• Introducing Latches and Mutex 2 of 2
• Handling Latch and Mutex Contention 1 of 2
• Handling Latch and Mutex Contention 2 of 2
• Handling Cache Buffer Chain (CBC) Latch 1 of 2
• Handling Cache Buffer Chain (CBC) Latch 2 of 2
• Handling Other Latch Types 1 of 2
• Handling Other Latch Types 2 of 2
• Practice 19 - Handling Latch and Mutex Contention 1 of 4
• Practice 19 - Handling Latch and Mutex Contention 2 of 4
• Practice 19 - Handling Latch and Mutex Contention 3 of 4
• Practice 19 - Handling Latch and Mutex Contention 4 of 4

21. Tuning the Shared Pool

• Tuning the Shared Pool 1 of 4
• Tuning the Shared Pool 2 of 4
• Tuning the Shared Pool 3 of 4
• Tuning the Shared Pool 4 of 4
• Sizing the Shared Pool
• Practice 20 - Tuning the Shared Pool 1 of 2
• Practice 20 - Tuning the Shared Pool 2 of 2
• Caching Session Cursors 1 of 2
• Caching Session Cursors 2 of 2
• Practice 21 - Caching Session Cursors 1 of 2
• Practice 21 - Caching Session Cursors 2 of 2
• Managing Server Result Cache 1 of 2
• Managing Server Result Cache 2 of 2
• Practice 22 - Managing Server Result Cache 1 of 2
• Practice 22 - Managing Server Result Cache 2 of 2

22. Tuning the Buffer Cache

• Tuning the Buffer Cache 1 of 5
• Tuning the Buffer Cache 2 of 5
• Tuning the Buffer Cache 3 of 5
• Tuning the Buffer Cache 4 of 5
• Tuning the Buffer Cache 5 of 5
• Practice 23 - Tuning the Buffer Cache 1 of 3
• Practice 23 - Tuning the Buffer Cache 2 of 3
• Practice 23 - Tuning the Buffer Cache 3 of 3
• Using Smart Flash Cache 1 of 3
• Using Smart Flash Cache 2 of 3
• Using Smart Flash Cache 3 of 3
• Practice 24 - Using Smart Flash Cache 1 of 2
• Practice 24 - Using Smart Flash Cache 2 of 2

23. Tuning the PGA

• Tuning the PGA 1 of 6
• Tuning the PGA 2 of 6
• Tuning the PGA 3 of 6
• Tuning the PGA 4 of 6
• Tuning the PGA 5 of 6
• Tuning the PGA 6 of 6
• Practice 25 - Tuning the PGA 1 of 3
• Practice 25 - Tuning the PGA 2 of 3
• Practice 25 - Tuning the PGA 3 of 3

24. Tuning the Redo Path

• Tuning the Redo Path 1 of 4
• Tuning the Redo Path 2 of 4
• Tuning the Redo Path 3 of 4
• Tuning the Redo Path 4 of 4
• Practice 26 - Tuning the Redo Path

25. Detecting CPU Bottlenecks

• Detecting CPU Bottlenecks 1 of 2
• Detecting CPU Bottlenecks 2 of 2
• Practice 27 - Detecting CPU Bottlenecks 1 of 2
• Practice 27 - Detecting CPU Bottlenecks 2 of 2

26. Tuning Disk IO Operations in Oracle Database

• Tuning Disk IO Operations in Oracle Database 1 of 8
• Tuning Disk IO Operations in Oracle Database 2 of 8
• Tuning Disk IO Operations in Oracle Database 3 of 8
• Tuning Disk IO Operations in Oracle Database 4 of 8
• Tuning Disk IO Operations in Oracle Database 5 of 8
• Tuning Disk IO Operations in Oracle Database 6 of 8
• Tuning Disk IO Operations in Oracle Database 7 of 8
• Tuning Disk IO Operations in Oracle Database 8 of 8
• Practice 28 - Tuning Disk IO Operations in Oracle Database 1 of 2
• Practice 28 - Tuning Disk IO Operations in Oracle Database 2 of 2

27. Maintaining In-Production Indexes for Performance

• Maintaining In-Production Indexes for Performance 1 of 5
• Maintaining In-Production Indexes for Performance 2 of 5
• Maintaining In-Production Indexes for Performance 3 of 5
• Maintaining In-Production Indexes for Performance 4 of 5
• Maintaining In-Production Indexes for Performance 5 of 5
• Practice 29 - Performing Index Defragmentation 1 of 2
• Practice 29 - Performing Index Defragmentation 2 of 2

28. Handling Row Migration and Row Chaining

• Introducing Row Migration and Row Chaining 1 of 2
• Introducing Row Migration and Row Chaining 2 of 2
• Handling Row Migration and Row Chaining 1 of 3
• Handling Row Migration and Row Chaining 2 of 3
• Handling Row Migration and Row Chaining 3 of 3
• Practice 30 - Handling Row Migration and Row Chaining 1 of 3
• Practice 30 - Handling Row Migration and Row Chaining 2 of 3
• Practice 30 - Handling Row Migration and Row Chaining 3 of 3

29. Diagnosing Table Fragmentation

• Diagnosing Table Fragmentation 1 of 2
• Diagnosing Table Fragmentation 2 of 2
• Practice 31 - Diagnosing Table Fragmentation

30. Using Table Compression

• Using Table Compression 1 of 3
• Using Table Compression 2 of 3
• Using Table Compression 3 of 3
• Practice 32 - Using Table Compression 1 of 2
• Practice 32 - Using Table Compression 2 of 2

31. Introducing In-Memory Column Store

• Introducing In-Memory Column Store 1 of 3
• Introducing In-Memory Column Store 2 of 3
• Introducing In-Memory Column Store 3 of 3
• Practice 33 - Introducing In-Memory Column Store

32. Optimizing Database Connection

• Optimizing Database Connection 1 of 6
• Optimizing Database Connection 2 of 6
• Optimizing Database Connection 3 of 6
• Optimizing Database Connection 4 of 6
• Optimizing Database Connection 5 of 6
• Optimizing Database Connection 6 of 6
• Practice 34 - Optimizing Database Connection

33. Monitoring Oracle Database Performance Using EM Database Express

• Monitoring Oracle Database Performance Using EM Database Express
• Using Oracle EM Express for Performance Tuning - Demo 1 of 5
• Using Oracle EM Express for Performance Tuning - Demo 2 of 5
• Using Oracle EM Express for Performance Tuning - Demo 3 of 5
• Using Oracle EM Express for Performance Tuning - Demo 4 of 5
• Using Oracle EM Express for Performance Tuning - Demo 5 of 5

34. Monitoring OS Performance Using Linux Utilities

• Monitoring OS Performance Using Linux Utilities 1 of 2
• Monitoring OS Performance Using Linux Utilities 2 of 2
• Practice 35 - Monitoring OS Performance Using Linux Utilities 1 of 5
• Practice 35 - Monitoring OS Performance Using Linux Utilities 2 of 5
• Practice 35 - Monitoring OS Performance Using Linux Utilities 3 of 5
• Practice 35 - Monitoring OS Performance Using Linux Utilities 4 of 5
• Practice 35 - Monitoring OS Performance Using Linux Utilities 5 of 5
• Using OSWatcher Black Box 1 of 3
• Using OSWatcher Black Box 2 of 3
• Using OSWatcher Black Box 3 of 3
• Practice 36 - Using OSWatcher Black Box 1 of 2
• Practice 36 - Using OSWatcher Black Box 2 of 2

35. Using SQL Performance Analyzer

• Using SQL Performance Analyzer 1 of 3
• Using SQL Performance Analyzer 2 of 3
• Using SQL Performance Analyzer 3 of 3
• Practice 37 - Using SQL Performance Analyzer 1 of 2
• Practice 37 - Using SQL Performance Analyzer 2 of 2

36. Using Database Replay

• Using Database Replay 1 of 4
• Using Database Replay 2 of 4
• Using Database Replay 3 of 4
• Using Database Replay 4 of 4
• Practice 38 - Using Database Replay 1 of 7
• Practice 38 - Using Database Replay 2 of 7
• Practice 38 - Using Database Replay 3 of 7
• Practice 38 - Using Database Replay 4 of 7
• Practice 38 - Using Database Replay 5 of 7
• Practice 38 - Using Database Replay 6 of 7
• Practice 38 - Using Database Replay 7 of 7