⚡ Advanced Level

Oracle Database
Performance Tuning

หลักสูตรเชิงลึกสำหรับการ Tune ประสิทธิภาพฐานข้อมูล Oracle ครอบคลุม AWR, ADDM, SQL Tuning, Memory Management และ Database Replay

📅 4 วัน
🕘 09:00 – 16:00 น.
💻 Interactive Online Classroom
💰 30,000 ฿

📋 เนื้อหาหลักสูตร (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