Oracle Database: Performance Management and Tuning Eğitimi

  • Eğitim Tipi: Classroom
  • Süre: 5 Gün
  • Seviye: Expert
Bu eğitimi kendi kurumunuzda planlayabilirsiniz. Bize Ulaşın!

  • Use the Oracle tuning methodology
  • Use Oracle-supplied tools for monitoring and diagnosing SQL and instance tuning issues
  • Use database advisors to proactively correct performance problems
  • Identify problem SQL statements
  • Tune SQL performance problems
  • Monitor instance performance by using Enterprise Manager
  • Tune instance components by primarily using instance parameter

Audience

  • Administrator
  • Database Administrator

Suggested Prerequisite
  • Oracle Database 12c R2: Install and Upgrade Workshop Ed 2
  • Familiarity with Oracle Database installation
  • Familiarity with Oracle Database configuration concepts
Required Prerequisite
  • Oracle Database 18c: Administration Workshop Ed 1
  • Basic knowledge of Linux operating system
  • A working knowledge of SQL and PL/SQL packages
  • Basic understanding of Oracle Database architecture
  • Familiarity with basic database monitoring procedures

  • Use the Oracle Database tuning methodology appropriate to the available tools
  • Utilize database advisors to proactively tune an Oracle Database Instance
  • Use the tools based on the Automatic Workload Repository to tune the database
  • Diagnose and tune common SQL related performance problems
  • Diagnose and tune common Instance related performance problems
  • Use Enterprise Manager performance-related pages to monitor an Oracle Database

  • Introduction
  • Defining the Scope of Performance Issues
  • Using AWR-Based Tools
  • Identifying Problem SQL Statements
  • Using SQL Performance Analyzer
  • Tuning the Shared Pool
  • Automatic Memory
  • Basic Tuning Diagnostics
  • Using Metrics and Alerts
  • Real-Time Database Operation Monitoring
  • Influencing the Optimizer
  • SQL Performance Management
  • Tuning the Buffer Cache
  • Performance Tuning Summary with Waits
  • Using Automatic Workload Repository
  • Using Baselines
  • Monitoring Applications
  • Reducing the Cost of SQL Operations
  • Using Database Replay
  • Tuning PGA and Temporary Space


Eğitimlerle ilgili bilgi almak ve diğer tüm sorularınız için bize ulaşın!

Yakın tarihte açılacak eğitimler

Sınıf eğitimlerimizi İstanbul, Ankara ve Londra ofislerimizde düzenlemekteyiz. Kurumunuza özel eğitimleri ise, dilediğiniz tarih ve lokasyonda organize edebiliriz.

Classroom / Virtual Classroom
07 Nisan 2024
İstanbul, Ankara, Londra
5 Gün
Classroom / Virtual Classroom
13 Nisan 2024
İstanbul, Ankara, Londra
5 Gün
Classroom / Virtual Classroom
23 Mayıs 2024
İstanbul, Ankara, Londra
5 Gün
Classroom / Virtual Classroom
21 Haziran 2024
İstanbul, Ankara, Londra
5 Gün
Classroom / Virtual Classroom
25 Haziran 2024
İstanbul, Ankara, Londra
5 Gün
Classroom / Virtual Classroom
02 Ağustos 2024
İstanbul, Ankara, Londra
5 Gün
Classroom / Virtual Classroom
11 Ağustos 2024
İstanbul, Ankara, Londra
5 Gün
Classroom / Virtual Classroom
10 Ağustos 2024
İstanbul, Ankara, Londra
5 Gün
Sitemizi kullanarak çerezlere (cookie) izin vermektesiniz. Detaylı bilgi için Çerez Politika'mızı inceleyebilirsiniz.