Oracle Database Administration - Oracle Database Certification

The Knowledge Academy
En Cardiff (Gales)

£ 2,475 - ($ 55,904)
más IVA

Información importante

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

Course Manual Certificates Experienced instructors Refreshments

Información importante

Dónde se imparte y en qué fechas

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

¿Qué aprendes en este curso?

Database Administration
Database training
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:


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


  • 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
  • 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