Course Modules
Módulo I: Introducción
Fundamentos del rendimiento en Oracle y el ciclo de vida de una consulta SQL.
Módulo II: Diagnóstico de ajuste básico
Uso de herramientas como EXPLAIN PLAN, TKPROF, y vistas V$ para diagnóstico inicial.
Módulo III: Uso de AWR
Implementación del Automatic Workload Repository para analizar métricas históricas.
Módulo IV: Definición de problemas de rendimiento
Identificación de cuellos de botella en SQL, instancia, red y disco.
Módulo V: Uso de métricas y alertas
Configuración y monitoreo con métricas y alertas automáticas.
Módulo VI: Uso de líneas base
Creación de líneas base para comparación de rendimiento.
Módulo VII: Herramientas basadas en AWR
Uso avanzado de AWR, ADDM y ASH para ajuste de rendimiento.
Módulo VIII: Monitoreo en tiempo real
Supervisión activa de sesiones, bloqueos y carga con Enterprise Manager.
Módulo IX: Aplicaciones de monitoreo
Integración de soluciones de monitoreo corporativas.
Módulo X: Identificación de SQL problemático
Localización y análisis de sentencias SQL con alto costo.
Módulo XI: Influencia sobre el optimizador
Uso de hints, estadísticas, y directivas para modificar planes de ejecución.
Módulo XII: Reducción de costo SQL
Optimizar consultas mediante reescritura, índices y estructuras eficientes.
Módulo XIII: SQL Performance Analyzer
Comparación de rendimiento antes y después de cambios.
Módulo XIV: Gestión del rendimiento SQL
Priorización de recursos y control de cargas de trabajo SQL.
Módulo XV: Database Replay
Simulación de cargas reales para validar ajustes sin riesgo.
Módulo XVI: Ajuste de Shared Pool
Optimización de estructuras como la librería de SQL y caché de cursores.
Módulo XVII: Ajuste de Buffer Cache
Mejora del uso del buffer de bloques para reducir accesos a disco.
Módulo XVIII: Ajuste de PGA y espacio temporal
Configuración adecuada para operaciones que requieren gran uso de memoria.
Módulo XIX: Memoria Automática
Uso de MEMORY_TARGET y ajustes automáticos de SGA y PGA.
Módulo XX: Resumen con enfoque en "esperas"
Evaluación integral usando Wait Interface para priorizar acciones de ajuste.
Current process description
This program offers advanced training in management and optimization of Oracle 19C database performance, focusing on the application of adjustment, monitoring and diagnosis strategies to improve the efficiency and stability of business databases.
The course prepares participants to obtain international certification:
Oracle Database 19C: Performance Management and Tuning (1Z0-084)-Oracle Certified Professional (OCP).
This program is aimed at database administrators (DBAS) and developers who seek to specialize in adjustment and optimization of Oracle 19C database performance.
Objectives
At the end of the course, participants will be able to:
- • Fundamentals of optimization and monitoring
- • Use the Oracle database adjustment methodology with specialized tools
- • Configure and administer the Automatic Workload Repository (AWR)
- • Apply proactive adjustment strategies to avoid performance problems
- • Monitoring and diagnosis of performance problems
- • Use Oracle Enterprise Manager to monitor databases in real time
- • Diagnose and adjust common performance problems in SQL
- • Optimize SQL queries and reduce the cost of operations
- • Supervise work loads in Oracle databases and improve efficiency
- • Advanced performance management
- • Adjust the shared memory and the buffer cache in Oracle
- • Optimize the performance of the PGA and the temporal space
- • Implement SQL Performance Analyzer and carry out load tests
- • Adjust the resource configuration and optimize the use of automatic memory
- • Use Oracle diagnostic tools to improve efficiency
Prerequisites
To participate in this training, attendees must meet the following requirements:
- • Basic knowledge of the Linux operating system
- • Experience in relational databases and administration of Oracle
- • Having worked with SQL and PL/SQL in business environments
- • Familiarity with the installation and configuration of Oracle Database
- • Prior knowledge in monitoring and diagnosis of databases
- These requirements guarantee that participants can focus on the advanced optimization of Oracle databases without initial technical difficulties
What Does This Course Include?
| Our Value Proposition | Benefit for Participant or Company |
|---|---|
| Oracle Database 19C: Performance Management and Tuning | 40 hours |
| • E-learning reinforcement topics and exclusive materials and simulators | • Complementary platform with digital resources, study guides, support recordings and exam simulators. |
| • Flexible educational model (in-person or live remote) | • Possibility to choose modality without losing human interaction and teaching support. |
| • Focus on employability and professional performance and exam preparation. | • Preparation oriented to certification, job performance and professional scaling based on practice, enhanced with AI support. |
| • Integration of Artificial Intelligence in learning | • Students use AI tools to reinforce understanding, practice exams and enhance their productivity. |
| • International Certification included | • Official endorsement with global recognition. Includes certification exams and access to the partner platform. |
| • Laboratories in real learning environments. | • Unlimited practical experience with real lab accounts and access to professional cloud infrastructure. |
| • Live classes with certified expert instructors. | • Guided and personalized training with direct real-time support, not offline. Recorded classes only for review. |
| • Personalized attention, small groups. | • Individual tracking, progress evaluations and technical support during training. AI-proctored performance examiner. |
| • Post-certification support and extended access to resources | • Post-assistance, access to materials for and continuous updates. |
| • Practical methodology and real and/or simulated projects. | • Applied learning from day one: simulations, business cases, projects and real cloud environments. |
| • Certificates of Approval and/or participation. | • International Certification by Oracle Academy
• Infinity Training Institute USA: International Certification Diploma in English • Aula Matriz IETDH Colombia - Certificate of participation |
Why choose Infinity Training Institute?
All our courses are Internationally certified:
- Infinity Training Institute USA: International Certification Diploma in English.
- International Certification from our partners Microsoft, Oracle, Certitalents, AWS, PMI, Cisco, etc.
2. We are not an automatic platform, nor self-study through videos
We are a unique model, in-person or Remote modality (with live instructor). Technology + pedagogy + AI + expert instructors + real practice — not self-study or outdated content.
3. Training designed for today's job market
Experience applicable immediately in interviews, technical tests and real work environments.
4. Real or simulated projects with international standards
Students access real environments such as Azure, AWS, Google Cloud, Oracle Cloud, develop real or simulated projects, building a demonstrable technical portfolio depending on the type of course or certification they have chosen.
5. A unique combination in Latin America and the USA
Certification + real practice + AI + continuous support + dual diploma.
6. Proven results
More than 95% of our graduates obtain official certification and improve professionally in less than six months.
7. Competency level guarantee
If the student during the practical training process does not reach a minimum performance level of 75%, they must repeat the course if the instructor determines so, and the student has shown the commitment and minimum class attendance required by the model.
Your professional future starts here
At Infinity Training Institute we boost your growth with an innovative, flexible model focused on real learning and performance evaluation. Certified instructors, intensive practice, integrated AI and constant support: world-class training.
Learning Methodology
At Infinity Training Institute, we apply a comprehensive, ever-evolving methodology centered on practical learning, powered by Artificial Intelligence, enabling personalized instruction, performance assessment, and optimized preparation for international certifications with certified instructors, real labs, simulators, and e-learning platforms. Participants learn by doing, developing technical and professional skills in small groups, with personalized follow-up and pre and post-certification support. Infinity Training Institute: Learn. Apply. Get Certified. Transcend.
Current process description
This program offers advanced training in management and optimization of Oracle 19C database performance, focusing on the application of adjustment, monitoring and diagnosis strategies to improve the efficiency and stability of business databases.
The course prepares participants to obtain international certification:
Oracle Database 19C: Performance Management and Tuning (1Z0-084)-Oracle Certified Professional (OCP).
This program is aimed at database administrators (DBAS) and developers who seek to specialize in adjustment and optimization of Oracle 19C database performance.
Objectives
At the end of the course, participants will be able to:
- • Fundamentals of optimization and monitoring
- • Use the Oracle database adjustment methodology with specialized tools
- • Configure and administer the Automatic Workload Repository (AWR)
- • Apply proactive adjustment strategies to avoid performance problems
- • Monitoring and diagnosis of performance problems
- • Use Oracle Enterprise Manager to monitor databases in real time
- • Diagnose and adjust common performance problems in SQL
- • Optimize SQL queries and reduce the cost of operations
- • Supervise work loads in Oracle databases and improve efficiency
- • Advanced performance management
- • Adjust the shared memory and the buffer cache in Oracle
- • Optimize the performance of the PGA and the temporal space
- • Implement SQL Performance Analyzer and carry out load tests
- • Adjust the resource configuration and optimize the use of automatic memory
- • Use Oracle diagnostic tools to improve efficiency
Prerequisites
To participate in this training, attendees must meet the following requirements:
- • Basic knowledge of the Linux operating system
- • Experience in relational databases and administration of Oracle
- • Having worked with SQL and PL/SQL in business environments
- • Familiarity with the installation and configuration of Oracle Database
- • Prior knowledge in monitoring and diagnosis of databases
- These requirements guarantee that participants can focus on the advanced optimization of Oracle databases without initial technical difficulties
What Does This Course Include?
| Our Value Proposition | Benefit for Participant or Company |
|---|---|
| Oracle Database 19C: Performance Management and Tuning | 40 hours |
| • E-learning reinforcement topics and exclusive materials and simulators | • Complementary platform with digital resources, study guides, support recordings and exam simulators. |
| • Flexible educational model (in-person or live remote) | • Possibility to choose modality without losing human interaction and teaching support. |
| • Focus on employability and professional performance and exam preparation. | • Preparation oriented to certification, job performance and professional scaling based on practice, enhanced with AI support. |
| • Integration of Artificial Intelligence in learning | • Students use AI tools to reinforce understanding, practice exams and enhance their productivity. |
| • International Certification included | • Official endorsement with global recognition. Includes certification exams and access to the partner platform. |
| • Laboratories in real learning environments. | • Unlimited practical experience with real lab accounts and access to professional cloud infrastructure. |
| • Live classes with certified expert instructors. | • Guided and personalized training with direct real-time support, not offline. Recorded classes only for review. |
| • Personalized attention, small groups. | • Individual tracking, progress evaluations and technical support during training. AI-proctored performance examiner. |
| • Post-certification support and extended access to resources | • Post-assistance, access to materials for and continuous updates. |
| • Practical methodology and real and/or simulated projects. | • Applied learning from day one: simulations, business cases, projects and real cloud environments. |
| • Certificates of Approval and/or participation. | • International Certification by Oracle Academy
• Infinity Training Institute USA: International Certification Diploma in English • Aula Matriz IETDH Colombia - Certificate of participation |
Why choose Infinity Training Institute?
1. Internationally guaranteed certificationsAll our courses are Internationally certified:
- Infinity Training Institute USA: International Certification Diploma in English.
- International Certification from our partners Microsoft, Oracle, Certitalents, AWS, PMI, Cisco, etc.
2. We are not an automatic platform, nor self-study through videos
We are a unique model, in-person or Remote modality (with live instructor). Technology + pedagogy + AI + expert instructors + real practice — not self-study or outdated content.
3. Training designed for today's job market
Experience applicable immediately in interviews, technical tests and real work environments.
4. Real or simulated projects with international standards
Students access real environments such as Azure, AWS, Google Cloud, Oracle Cloud, develop real or simulated projects, building a demonstrable technical portfolio depending on the type of course or certification they have chosen.
5. A unique combination in Latin America and the USA
Certification + real practice + AI + continuous support + dual diploma.
6. Proven results
More than 95% of our graduates obtain official certification and improve professionally in less than six months.
7. Competency level guarantee
If the student during the practical training process does not reach a minimum performance level of 75%, they must repeat the course if the instructor determines so, and the student has shown the commitment and minimum class attendance required by the model.
Your professional future starts here
At Infinity Training Institute we boost your growth with an innovative, flexible model focused on real learning and performance evaluation. Certified instructors, intensive practice, integrated AI and constant support: world-class training.
Learning Methodology
At Infinity Training Institute, we apply a comprehensive, ever-evolving methodology centered on practical learning, powered by Artificial Intelligence, enabling personalized instruction, performance assessment, and optimized preparation for international certifications with certified instructors, real labs, simulators, and e-learning platforms. Participants learn by doing, developing technical and professional skills in small groups, with personalized follow-up and pre and post-certification support. Infinity Training Institute: Learn. Apply. Get Certified. Transcend.