Duración

5 días - 30 horas

Descripción

Students learn how to use Oracle Database automatic tuning features such as SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database Diagnostic Monitor, and practice these tuning methods. The course focuses on the tuning tasks expected of a DBA: reactive tuning of SQL statements, maintaining SQL statement and operation performance, and tuning the Oracle Database Instance components.

Objetivos

  • 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

Contenidos del curso

  1. Introduction
  2. Basic Tuning Diagnostics
  3. Using Automatic Workload Repository
  4. Defining the Scope of Performance Issues
  5. Using Metrics and Alerts
  6. Using Baselines
  7. Using AWR-Based Tools
  8. Real-Time Database Operation Monitoring
  9. Monitoring Applications
  10. Identifying Problem SQL Statements
  11. Influencing the Optimizer
  12. Reducing the Cost of SQL Operations
  13. Using SQL Performance Analyzer
  14. SQL Performance Management
  15. Using Database Replay
  16. Tuning the Shared Pool
  17. Tuning the Buffer Cache
  18. Tuning PGA and Temporary Space
  19. Automatic Memory
  20. Performance Tuning Summary with Waits


Información extra

Audience

  • Administrators
  • Database Administrators

Learn to

  • 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 parameters

Related Training

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

Información general

Área formativa

Cursos ELS Oracle Database

Fabricante

Oracle

Metodología

Presencial | Learning virtual class

Certificación

Propia del fabricante

 

¿TIENES DUDAS? PREGÚNTANOS

    He leído y acepto la del sitio y las condiciones de tratamiento de mis datos de carácter personal

     

     

    Fecha y precios de nuestros cursos

    Fecha Horario de impartición Ubicación Precio por alumno Previsto en fecha
    No hay convocatoria programada. Por favor, consúltanos sobre próximas fechas y precio para esta formación.

    ¿Necesitas Ayuda?

    Consúltanos si necesitas información de nuestros cursos o masters.

     

    Contacta con Core Networks