Quality Seal Emagister EMAGISTER CUM LAUDE

Oracle Database Administration - Oracle Database Certification

The Knowledge Academy
En Cardiff (Gales)

£ 2,475 - ($ 63,433)
más IVA

Información importante

  • Curso
  • Cardiff (Gales)
  • Duración:
    5 Days
  • Cuándo:
    A definir
Descripción

Course Manual Certificates Experienced instructors Refreshments

Información importante
Instalaciones

Dónde se imparte y en qué fechas

Inicio Ubicación
A definir
Cardiff
Castle Street, CF10 1SZ, Cardiff, Gales
Ver mapa

¿Qué aprendes en este curso?

IT
Database
SQL
Database Administration
Database training
Performance
Database training
Database Administration

Programa académico

The Knowledge Academy Oracle Database 11g: Performance Tuning DBA Release 2 5 day course covers the following topics:

Introduction

This course looks at the steps needed for a database to perform and identify problems, diagnose issues and fixing them too.

Pre-Requisites

  • Delegates are required to have had some experience or knowledge of Oracle database 11g administration.

Who should attend?

This course is for:

  • Support Engineers
  • Database Administrators
  • Technical Consultants

What will you learn?

  • The ability to describe Oracle tuning methodology
  • The ability to use Oracle supplied tools for monitoring and diagnosing SQL and Instance tuning issues
  • The ability to use database advisors to correct performance problems proactively
  • The ability to identify problem SQL statements & tune SQL performance problems
  • The ability to monitor the Instance Performance using Enterprise Manager
  • The ability to tune instance components, primarily using Instance parameters

Course Outline

  • Introduction to the Basic Tuning Tools
  • Implementing Automatic Workload Repository
  • Identifying Problems
  • Implementing Metrics and Alerts
  • Implementing Baselines
  • Implementing AWR Based Tools
  • Overview of Monitoring an Application
  • Overview of Problem SQL Statements
  • Understanding ways of Influencing the Optimizer
  • Implementing SQL Performance Analyser
  • SQL Performance Management overview
  • Implementing Database Replay
  • Overview of Tuning the Shared Pool and the Buffer Cache
  • Overview of Tuning PGA and Temporary Space
  • Introduction to Automatic Memory Management
  • Understanding Tuning Segment Space Usage and I/O
  • Overview of Performance Tuning Summary

Información adicional

  • Gain an understanding of the Oracle Database 11g Performance Tuning
  • Learn the key tools and tuning methods of identify problems
  • Develop knowledge of implementing problem solutions
  • GUARANTEED LOWEST PRICE IN THE INDUSTRY
  • Courses delivered by world class training instructors
  • Training provided in luxury venues
  • Includes material and manuals
  • Book Online or Call 01344 203999 to speak to a training advisor today