Oracle Database: Performance Management and Tuning Eğitimi
Eğitim Tipi: Classroom
Süre: 5 Gün
Seviye: Expert
En Yakın Tarih: 24 Eylül 2024
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
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
24 Eylül 2024
İstanbul, Ankara, Londra
5 Gün
Classroom / Virtual Classroom
27 Eylül 2024
İstanbul, Ankara, Londra
5 Gün
Classroom / Virtual Classroom
05 Ekim 2024
İstanbul, Ankara, Londra
5 Gün
Classroom / Virtual Classroom
07 Ekim 2024
İstanbul, Ankara, Londra
5 Gün
Classroom / Virtual Classroom
21 Ekim 2024
İstanbul, Ankara, Londra
5 Gün
Classroom / Virtual Classroom
23 Ekim 2024
İstanbul, Ankara, Londra
5 Gün
Classroom / Virtual Classroom
25 Ekim 2024
İstanbul, Ankara, Londra
5 Gün
Classroom / Virtual Classroom
01 Kasım 2024
İstanbul, Ankara, Londra
5 Gün
Bilginç IT Academy Tüm Hakları Saklıdır
Sitemizi kullanarak çerezlere (cookie) izin vermektesiniz. Detaylı bilgi için Çerez Politika'mızı inceleyebilirsiniz.