⚡ Advanced Level
Oracle Database
Oracle Database
Performance Tuning
หลักสูตรเชิงลึกสำหรับการ Tune ประสิทธิภาพฐานข้อมูล Oracle ครอบคลุม AWR, ADDM, SQL Tuning, Memory Management และ Database Replay
📋 เนื้อหาหลักสูตร (Course Outline)
📚 Day 1
- Lesson 1: Introduction to Tuning
- Lesson 2: Basic Tuning Tools
- Lesson 3: Using Automatic Workload Repository (AWR)
- Lesson 4: Defining Problems
📚 Day 2
- Lesson 5: Using Metrics and Alerts
- Lesson 6: Baselines
- Lesson 7: Using AWR-Based Tools (ADDM / ASH)
- Lesson 8: Monitoring an Application
📚 Day 3
- Lesson 9: Identifying Problem SQL Statements
- Lesson 10: Influencing the Optimizer
- Lesson 11: Using SQL Performance Analyzer
- Lesson 12: SQL Performance Management
📚 Day 4
- Lesson 13: Using Database Replay
- Lesson 14: Tuning the Shared Pool
- Lesson 15: Tuning the Buffer Cache
- Lesson 16: Tuning PGA and Temporary Space
- Lesson 17: Automatic Memory Management
- Lesson 18: Tuning Segment Space Usage