1. COURSE INTRODUCTION
2. PERFORMANCE TUNING OVERVIEW
- DATABASE PERFORMANCE TUNING CONTEXT
- THE DATABASE INSTANCE TUNING METHODOLOGY
3. STATISTICS & WAIT EVENTS
- ABOUT THE DYNAMIC PERFORMANCE VIEWS
- EXAMINING THE STATISTICS
- INTERPRETING THE STATISTICS
4. USING STATSPACK
- INSTALL THE STATSPACK UTILITY
- CREATE STATSPACK SNAPSHOTS
- GENERATE STATSPACK REPORTS
- IDENTIFY THE REPORT SECTIONS
5. AUTOMATIC TUNING & >AWR
- ABOUT THE MANAGEMENT & ADVISORY FRAMEWORK
- MANAGING THE AUTOMATIC WORKLOAD REPOSITORY
- ABOUT THE ACTIVE SESSION HISTORY (ASH)
- AUTOMATIC DATABASE DIAGNOSTIC MONITOR
- MANAGING SNAPSHOTS
- CREATE_BASELINE() & DROP_BASELINE()
- CREATE_SNAPSHOT() & DROP_SNAPSHOT_RANGE()
6. METRICS, ALERTS & BASELINES
- METRICS & ALERT THRESHOLDS
- MANAGING METRICS
- MANAGING ALERTS
- USE EM REAL-TIME MONITORS
7. TUNING MEMORY: THE SHARED POOL
- MORE ABOUT THE SHARED POOL
- DIAGNOSE SHARED POOL PROBLEMS
- KEEP OBJECTS IN THE SHARED POOL
8. TUNING MEMORY: THE BUFFER CACHE
- MORE ABOUT THE BUFFER CACHE
- REMEDY PERFORMANCE ISSUES
9. TUNING MEMORY: AUTOMATIC SHARED MEMORY
- AUTOMATIC SHARED MEMORY MANAGEMENT
- USING EM & THE MEMORY ADVISORS
10. TUNING I/O: CHECKPOINT & REDO TUNING
- TUNE REDO WRITING & ARCHIVING
- MTTR ADVISOR & TUNING CHECKPOINTS
- LOG_CHECKPOINTS_TO_ALERT
- ADDITIONAL REDO TUNING OPTIONS
11. TUNING I/O: DATABASE WRITES
12. SPACE TUNING: PGA & TEMPORARY SPACE
- PGA MEMORY MANAGEMENT
- TEMPORARY SPACE MANAGEMENT
13. SPACE TUNING: BLOCK SPACE USAGE
- USING THE SHRINK SPACE OPTION
- USING THE SEGMENT ADVISOR
|
