D50317 - Oracle Database 11g: Performance Tuning DBA

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.

Duration: 5.0

Enquire Now

Start learning today!

Click Hereto customize your Training

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

product-certification

This course is not associated with any Certification.

Course Benefits

product-benefits
  • Career growth
  • Broad Career opportunities
  • Worldwide recognition from leaders
  • Up-to Date technical skills
  • Popular Certification Badges

Oracle Popular Courses

d90871

This training is the first step in mastering MySQL, the world’s most popular open source database.

p10380

P10380 - Oracle Database 18c: Administration Workshop

d79995

Learn about Oracle SQL tuning and how to apply tuning techniques to your SQL code.

d83527

D83527 - Java SE 8 Fundamentals
Enquire Now
 
 
 
 
DawINE
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy