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

D79236 - Oracle Database 12c: Performance Management and Tuning

Overview

Duration: 5 days

In the Oracle Database 12c: Performance Management and Tuning course, learn about the performance analysis and tuning tasks expected of a DBA: proactive management through built-in performance analysis features and tools, diagnosis and tuning of the Oracle Database instance components, and diagnosis and tuning of SQL-related performance issues. In this course, you will be introduced to Oracle Database Cloud Service.

Learn To:

  • Use the Oracle tuning methodology.
  • Use Oracle-supplied tools for monitoring and diagnosing SQL and instance performance issues.
  • Use database advisors to proactively correct performance problems.
  • Identify and tune problem SQL statements.
  • Monitor instance performance by using Enterprise Manager.
  • Tune instance components.
  • Gain an understanding of the Oracle Database Cloud Service.

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
  • Gain an understanding of the Oracle Database Cloud Service

Audience

  • Database Administrators
  • Data Warehouse Administrator

Content

  • Module 1: Introduction
  • Module 2: Basic Tuning Diagnostics
  • Module 3: Using Automatic Workload Repository
  • Module 4: Defining the Scope of Performance Issues
  • Module 5: Using Metrics and Alerts
  • Module 6: Using Baselines
  • Module 7: Using AWR-Based Tools
  • Module 8: Real-Time Database Operation Monitoring
  • Module 9: Monitoring Applications
  • Module 10: Identifying Problem SQL Statements
  • Module 11: Influencing the Optimizer
  • Module 12: Reducing the Cost of SQL Operations
  • Module 13: Using SQL Performance Analyzer
  • Module 14: SQL Performance Management
  • Module 15: Using Database Replay
  • Module 16: Tuning the Shared Pool
  • Module 17: Tuning the Buffer Cache
  • Module 18: Tuning PGA and Temporary Space
  • Module 19: Automatic Memory
  • Module 20: Performance Tuning Summary with Waits
  • Module 21: Oracle Database Cloud Service: Overview

Prerequisites

  • Oracle Database 12c R2: Administration Workshop Ed 3

Suggested Prerequisites:

  • Oracle Database 12c: Install and Upgrade Workshop

Certification

This course is not associated with any Certification.

Schedule

Show Schedule for:




Enquire Now
 
 
 
 
By clicking "Submit", I agree to the Terms Of Use and Privacy Policy