Visão Geral

Este curso aborda técnicas avançadas de monitoramento, diagnóstico e otimização de desempenho em ambientes Oracle Database. O participante aprenderá a identificar gargalos, analisar cargas de trabalho, interpretar planos de execução, otimizar consultas SQL e ajustar componentes da infraestrutura Oracle para garantir alta performance, escalabilidade e disponibilidade dos bancos de dados corporativos.

Objetivo

Após realizar este curso, você será capaz de:

• Compreender a arquitetura de desempenho do Oracle Database
• Monitorar e diagnosticar problemas de performance
• Interpretar planos de execução e estatísticas do banco de dados
• Otimizar consultas SQL e aplicações PL/SQL
• Ajustar memória, armazenamento e recursos de processamento
• Implementar estratégias de monitoramento contínuo e melhoria de desempenho

Publico Alvo

• Administradores de Banco de Dados Oracle (DBAs)
• Analistas de banco de dados
• Desenvolvedores Oracle SQL e PL/SQL
• Arquitetos de soluções Oracle
• Especialistas em infraestrutura de dados
• Profissionais responsáveis pelo desempenho de ambientes Oracle

Pre-Requisitos

• Conhecimentos equivalentes ao curso Oracle Database Administration I
• Conhecimentos de SQL e PL/SQL
• Familiaridade com arquitetura Oracle Database

Conteúdo Programatico

Module 1: Oracle Performance Architecture Fundamentals

1. Introduction to Oracle performance tuning
2. Oracle performance architecture overview
3. Database workload characteristics
4. Performance tuning methodology
5. Performance metrics and indicators
6. Identifying common performance bottlenecks

Module 2: Monitoring and Diagnostic Tools

1. Oracle Enterprise Manager overview
2. Dynamic Performance Views (V$ Views)
3. Automatic Workload Repository (AWR)
4. Active Session History (ASH)
5. Automatic Database Diagnostic Monitor (ADDM)
6. Diagnostic and monitoring best practices

Module 3: SQL Performance Analysis

1. SQL execution lifecycle
2. Understanding execution plans
3. SQL trace and TKPROF
4. SQL Monitoring features
5. Identifying inefficient SQL statements
6. SQL performance troubleshooting techniques

Module 4: SQL Optimization Techniques

1. Optimizer architecture and behavior
2. Cost-Based Optimizer fundamentals
3. Statistics collection and management
4. SQL rewriting techniques
5. Join optimization strategies
6. Query performance best practices

Module 5: Indexing Strategies and Optimization

1. Index architecture and structures
2. B-tree indexes
3. Bitmap indexes
4. Function-based indexes
5. Index maintenance and monitoring
6. Index tuning methodologies

Module 6: Memory Performance Tuning

1. Oracle memory architecture
2. System Global Area (SGA)
3. Program Global Area (PGA)
4. Automatic Memory Management
5. Shared pool optimization
6. Memory performance troubleshooting

Module 7: I/O and Storage Performance Tuning

1. Understanding Oracle I/O architecture
2. Storage subsystem considerations
3. Datafile and tablespace optimization
4. ASM performance fundamentals
5. Reducing I/O bottlenecks
6. Storage monitoring and analysis

Module 8: PL/SQL Performance Optimization

1. PL/SQL execution model
2. Reducing context switches
3. BULK COLLECT and FORALL operations
4. PL/SQL profiling techniques
5. Code optimization strategies
6. Performance testing methodologies

Module 9: Concurrency and Lock Management

1. Transaction management performance
2. Locking and blocking analysis
3. Deadlock identification and resolution
4. Concurrency optimization techniques
5. Session management strategies
6. Resource contention troubleshooting

Module 10: Workload Management and Resource Optimization

1. Oracle Resource Manager fundamentals
2. Managing database workloads
3. Capacity planning concepts
4. Performance baselines
5. Service-level management
6. Resource allocation strategies

Module 11: Advanced Performance Tuning Techniques

1. Performance tuning methodologies
2. Real Application Testing overview
3. SQL Plan Management
4. Adaptive query optimization
5. Performance tuning automation
6. Continuous performance improvement practices

Module 12: Performance Workshops and Enterprise Case Studies

1. SQL tuning workshops
2. AWR and ASH analysis exercises
3. Database performance troubleshooting labs
4. Real-world performance tuning scenarios
5. Capacity planning exercises
6. Final Oracle performance optimization project