Performance Management

Oracle Database 11g: Performance Tuning DBA

Código: D50317GC20
Duración: 30 horas (5 días)

Fechas previstas: Curso bajo demanda

Descripción

The course starts with an unknown database that requires tuning. The lessons will proceed through the steps a DBA will perform to acquire the information needed to identify problem areas, to diagnose common problems, and remedy those problems. The methodology used in the practices is primarily reactive.

Oracle Database 11g: SQL Tuning Workshop

Código: D52163GC20
Duración: 18 horas (3 días)

Fechas previstas: Curso bajo demanda

Descripción

This course assists database developers, DBAs, and SQL developers to identify and tune inefficient SQL statement. It covers investigative methods to reveal varying levels of detail about how the Oracle database executes the SQL statement. This allows the student to determine the root causes of the inefficient SQL statements.

Oracle Database 11g: Administración Data Guard

Código: D52161GC30
Duración: 24 horas (4 días)

Fechas previstas: Curso bajo demanda

Descripción

In this course, students learn how to use Oracle Data Guard to help protect their Oracle database against planned and unplanned downtimes. They also learn how Data Guard standby databases can be used to support production functions such as reporting, querying, and testing, while in a standby role.

Oracle Database 11g: RAC Administration

Código: D60491GC20
Duración: 18 horas (3 días)

Fechas previstas: Curso bajo demanda

Descripción

In this course, students will learn about RAC database administration in the Oracle Grid Infrastructure environment. Students will learn to administer cluster databases using Enterprise Manager and command-line utilities like SRVCTL, CRSCTL, and SQL*Plus. Students will study the new connection architecture and how to make those connections highly available. Backup and recovery issues relative to cluster database environments will also be studied.