Wir beraten Sie gerne!
+49 40 253346-10     Kontakt

Online-Trainings im virtuellen Klassenraum,
E-Learning-Angebote und mehr

Jetzt informieren

Oracle Database: Performance Management and Tuning (D105019)

 

Zielgruppe

  • Administrator
  • Database Administrator

Voraussetzungen

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

Kursziele

  • 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

Kursinhalt

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

Dauer 5 Tage

Preis (exkl. MwSt.)
  • 3.315,- €
Digitale Kursunterlagen

Sprache der Kursunterlagen: Englisch

Classroom Training

Dauer 5 Tage

Preis (exkl. MwSt.)
  • Deutschland: 3.555,- €
  • Schweiz: 3.555,- €
Digitale Kursunterlagen

Sprache der Kursunterlagen: Englisch

E-Learning Oracle Training on Demand

Dauer 90 Tage

Preis (exkl. MwSt.)
  • Deutschland: 2.925,- €
E-Learning kaufen
 

Kurstermine

Deutschland
31.08. ― 04.09.2020 Dresden
12.10. ― 16.10.2020 Berlin
12.10. ― 16.10.2020 Dresden
26.10. ― 30.10.2020 München
02.11. ― 06.11.2020 München