Oracle Database Administration - Oracle Database Certification

Course

In Cardiff

£ 2,475 + VAT

Description

  • Type

    Course

  • Location

    Cardiff (Wales)

  • Duration

    5 Days

  • Start date

    Different dates available

Course Manual Certificates Experienced instructors Refreshments

Facilities

Location

Start date

Cardiff
See map
Castle Street, CF10 1SZ

Start date

Different dates availableEnrolment now open

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2016

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 8 years

Subjects

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

Course programme

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

Additional information

  • 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        

Oracle Database Administration - Oracle Database Certification

£ 2,475 + VAT