trainocate-oracle-training-b
Home > Vendors > Oracle > d50317

D50317 - Oracle Database 11g: Performance Tuning DBA

Overview

Duration: 5 days

This Oracle Database 11g Performance Tuning training starts with an unknown database that requires tuning. You’ll then learn the steps a DBA performs to identify problem areas, diagnose common problems and fix them.

Learn To:

  • Describe Oracle tuning methodology.
  • Use Oracle supplied tools for monitoring and diagnosing SQL and Instance tuning issues.
  • Use database advisors to correct performance problems proactively.
  • Identify problem SQL statements & tune SQL performance problems.
  • Monitor the Instance Performance using Enterprise Manager.
  • Tune instance components, primarily using Instance parameters.

Objectives

Upon completing this course, the learner will be able to meet these overall objectives:
  • Use the Oracle Database tuning methodology appropriate to the available tools
  • Utilize database advisors to proactively tune an Oracle Database Instance
  • Use the tools based on the Automatic Workload Repository to tune the database
  • Diagnose and tune common SQL related performance problems
  • Diagnose and tune common Instance related performance problems
  • Use Enterprise Manager performance-related pages to monitor an Oracle Database

Content

Module 1: Introduction
Module 2: Monitoring With Basic Tools
Module 3: Using Automatic Workload Repository
Module 4: Identifying the Problem
Module 5: Identifying Problem SQL Statements
Module 6: Influencing the Optimizer
Module 7: SQL Plan Management
Module 8: Change Management
Module 9: Using Metrics and Alerts
Module 10: Using AWR Based Tools
Module 11: Monitoring an Application (Using Services)
Module 12: Baselines
Module 13: Tuning the Shared Pool
Module 14: Tuning the Buffer Cache
Module 15: Tuning PGA and Temporary Space
Module 16: Automatic Memory Management
Module 17: Tuning Block Space Usage
Module 18: Tuning I/O
Module 19: Performance Tuning: Summary
Module 20: Using Statspack

Audience

  • Database Administrators
  • Support Engineer
  • Technical Consultant

Prerequisites

  • Oracle Database 11g: Administration Workshop I Release 2
  • Oracle Database 11g: Administration Workshop II Release 2

Certification

This course is not associated with any Certification.

Schedule

Show Schedule for: