Workshop

Oracle database performance tuning and monitoring for all editions («ODSQTE»)

In this workshop, you will learn how to perform performance tuning and monitoring in the Oracle database to ensure fast and secure operation of your applications.

Duration 3 days

Price 2'950.–

Course documents Digicomp digital courseware

Add to watch List

Course facts

Key Learnings

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

Content

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

Methodology & didactics

The participants receive theoretical knowledge, which is consolidated with many practical exercises.

Target audience

This workshop is intended for Oracle database administrators, operating system administrators and people involved in Oracle database operations.

Requirements

Basic knowledge of IT infrastructure is recommended. Oracle database administration knowledge and SQL basics as taught in the following courses are required.

5 days

CHF

3'950.–