Este programa usa herramientas como AWR y Active Session History para diagnosticar problemas. Aprenderás a mejorar el rendimiento de sentencias SQL influyendo en el optimizador y gestionando la memoria de la base de datos (SGA/PGA).
El programa está orientado a administradores de bases de datos o administradores de sistemas.
Módulo 1: Course Overview
Módulo 2: Performance Management Overview
Módulo 3: Defining the Scope of Performance Issues
Módulo 4: Using the Time Model to Diagnose Performance Issues
Módulo 5: Using Statistics and Wait Events to Diagnose Performance Issues
Módulo 6: Using Log and Trace Files to Monitor Performance
Módulo 7: Using Enterprise Manager Cloud Control and SQL Developer to Monitor Performance
Módulo 8: Using Statspack to View Performance Data
Módulo 9: Using Automatic Workload Repository
Módulo 10: Using Metrics and Alerts
Módulo 11: Using Baselines
Módulo 12: Managing Automated Maintenance Tasks
Módulo 13: Using ADDM to Analyze Performance
Módulo 14: Using Active Session History Data for First Fault System Analysis
Módulo 15: Using Emergency Monitoring and Real-Time ADDM to Analyze Performance Issues
Módulo 16: Overview of SQL Statement Processing
Módulo 17: Maintaining Indexes
Módulo 18: Maintaining Tables
Módulo 19: Introduction to Query Optimizer
Módulo 20: Understanding Execution Plans
Módulo 21: Viewing Execution Plans by Using SQL Trace and TKPROF
Módulo 22: Managing Optimizer Statistics
Módulo 23: Using Automatic SQL Tuning
Módulo 24: Using the SQL Plan Management Feature
Módulo 25: Overview of the SQL Advisors
Módulo 26: Using the SQL Tuning Advisor
Módulo 27: Using the SQL Access Advisor
Módulo 28: Overview of Real Application Testing Components
Módulo 29: Using SQL Performance Analyzer to Determine the Impact of Changes
Módulo 30: Using Database Replay to Test System Performance
Módulo 31: Implementing Real-Time Database Operation Monitoring
Módulo 32: Using Services to Monitor Applications
Módulo 33: Overview of Memory Structures
Módulo 34: Managing Shared Pool Performance
Módulo 35: Managing Buffer Cache Performance
Módulo 36: Managing PGA and Temporary Space Performance
Módulo 37: Configuring the Large Pool
Módulo 38: Using Automatic Shared Memory Management
Módulo 39: Introduction to In-Memory Column Store
Módulo 40: Configuring the In-Memory Column Store Feature
Módulo 41: Using the In-Memory Column Store Feature to Improve SQL Performance
Módulo 42: Using In-Memory Column Store with Oracle Database Features
Preparación para la certificación Oracle Certified Professional, Oracle Database 19c: Performance Management and Tuning Certification
Para acceder al programa, los interesados deben tener algunas de las siguientes certificaciones:
Información Adicional
Precio: 2.350,00 €
Otros cursos
