D108103GC10 – Oracle Database 19c: Performance Management and Tuning

Demostrar fluidez y una sólida comprensión del análisis, la gestión y el ajuste del rendimiento de Oracle Database 19c para un rendimiento óptimo en un entorno complejo.

Avatar del usuario
(0 comentario)

Requisitos

  • Overview
  • Defining the Scope of Performance Issues
  • Using the Time Model to Diagnose Performance Issues
  • Using Statistics and Wait Events to Diagnose Performance Issues
  • Using Log and Trace Files to Monitor Performance
  • Using Enterprise Manager Cloud Control and SQL Developer to Monitor Performance
  • Using Statspack to View Performance Data
  • Using Automatic Workload Repository
  • Using Metrics and Alerts
  • Using Baselines
  • Managing Automated Maintenance Tasks
  • Using ADDM to Analyze Performance
  • Using Active Session History Data for First Fault System Analysis
  • Using Emergency Monitoring and Real-Time ADDM to Analyze Performance Issues
  • Overview of SQL Statement Processing
  • Maintaining Indexes
  • Maintaining Tables
  • Introduction to Query Optimizer
  • Understanding Execution Plans
  • Viewing Execution Plans by Using SQL Trace and TKPROF
  • Using Automatic SQL Tuning
  • Using the SQL Plan Management Feature
  • Overview of the SQL Advisors
  • Using the SQL Tuning Advisor
  • Using the SQL Access Advisor
  • Overview of Real Application Testing Components
  • Using SQL Performance Analyzer to Determine the Impact of Changes
  • Using Database Replay to Test System Performance
  • Implementing Real-Time Database Operation Monitoring
  • Using Services to Monitor Applications
  • Overview of Memory Structures
  • Managing Shared Pool Performance
  • Managing Buffer Cache Performance
  • Managing PGA and Temporary Space Performance
  • Configuring the Large Pool
  • Using Automatic Shared Memory Management
  • Introduction to In-Memory Column Store
  • Configuring the In-Memory Column Store Feature
  • Using the In-Memory Column Store Feature to Improve SQL Performance
  • Using In-Memory Column Store with Oracle Database Features
Rol Audiencia Duración Idioma Curso Idioma Manual
Administrador 5 días, 40 Horas Español Inglés

 

DESCRIPCIÓN DEL CURSO

Demostrar fluidez y una sólida comprensión del análisis, la gestión y el ajuste del rendimiento de Oracle Database 19c para un rendimiento óptimo en un entorno complejo.

CERTIFICACIÓN

Oracle Database 19c: Performance Management and Tuning | 1Z0-084.

REQUISITOS

  • Oracle Database 19c: Administration Workshop.

Descargar Temario

Comentarios

promedio

0
0 puntuación

Evaluación detallada

5
0%
4
0%
3
0%
2
0%
1
0%

Deja una respuesta

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *