Workshop
Digicomp Code ODSQTE
Oracle database performance tuning and monitoring for all editions («ODSQTE»)
Course facts
- Understanding the impact of hardware (CPU, memory, storage) and virtualization
- Using the performance tools available in all Oracle editions
- Understanding object statistics and the Cost Based Optimizer
- Generating system and fixed object statistics
- Learning the basics of optimizing backup and recovery performance
Starting with an Oracle architecture overview, the influence of hardware (CPU, memory, storage) as well as virtualization is highlighted. The performance tools provided by Oracle including AWR are presented, but only those tools are used that are available in all Oracle editions. Beside the Database Performance Tuning there is also an insight into the topic Object Statistics and the Cost Based Optimizer, as far as it is relevant for a DBA. The useful generation of system and fixed object statistics is also covered as well as the basics of backup and recovery performance optimization. The course concludes with an overview of more advanced topics such as in-memory, partitioning, RAC, Data Guard and Oracle Exadata.
- Database server architecture
- Virtual versus physical servers
- UTLBSTAT/UTLESTAT, Perfstat and AWR reports
- CPU Basics
- Oracle database "CPU" time model and wait events
- Main Memory & Storage Basics
- Database Instance Memory Tuning: Buffer Cache, Shared Pool, SGA&PGA
- Network Performance Basics
- System Statistics and I/O Calibration
- Fixed and object statistics
- Cost Based Optimizer and Session Tracing
- Backup and Recovery Performance
- Monitoring for Oracle databases: Operating System and databases
- Overview of further performance tuning topics like In-Memory, Partitioning, RAC, Data Guard, Oracle Exadata
The participants receive theoretical knowledge, which is consolidated with many practical exercises.
This workshop is intended for Oracle database administrators, operating system administrators and people involved in Oracle database operations.
Basic knowledge of IT infrastructure is recommended. Oracle database administration knowledge and SQL basics as taught in the following courses are required.