25,000+ Courses Nationwide
0345 4506120

Oracle Database: Performance Management and Tuning

Specila Notice

Please note: In order to provision you with your courseware and lab access for this course we must share several items of basic personal information with our partner (usually your full name and email address).  If you have any questions or concerns please contact us.

Important Note: Your official Oracle digital course material now includes an additional 5 hours of content for you to consume after the course to help embed the learning. Your ELS will be accessible for 90 days from purchase.

  • Use the Oracle tuning methodology
  • Use Oracle-supplied tools for monitoring and diagnosing SQL and instance tuning issues
  • Use database advisors to proactively correct performance problems
  • Identify problem SQL statements
  • Tune SQL performance problems
  • Monitor instance performance by using Enterprise Manager
  • Tune instance components by primarily using instance parameter

Audience

  • Administrator
  • Database Administrator

Select specific date to see price, venue and full details.

Learning 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

Pre-Requisites

Suggested Prerequisite
  • Oracle Database 12c R2: Install and Upgrade Workshop Ed 2
  • Familiarity with Oracle Database installation
  • Familiarity with Oracle Database configuration concepts
Required Prerequisite
  • Oracle Database 18c: Administration Workshop Ed 1
  • Basic knowledge of Linux operating system
  • A working knowledge of SQL and PL/SQL packages
  • Basic understanding of Oracle Database architecture
  • Familiarity with basic database monitoring procedures

Course Content

  • Introduction
  • Defining the Scope of Performance Issues
  • Using AWR-Based Tools
  • Identifying Problem SQL Statements
  • Using SQL Performance Analyzer
  • Tuning the Shared Pool
  • Automatic Memory
  • Basic Tuning Diagnostics
  • Using Metrics and Alerts
  • Real-Time Database Operation Monitoring
  • Influencing the Optimizer
  • SQL Performance Management
  • Tuning the Buffer Cache
  • Performance Tuning Summary with Waits
  • Using Automatic Workload Repository
  • Using Baselines
  • Monitoring Applications
  • Reducing the Cost of SQL Operations
  • Using Database Replay
  • Tuning PGA and Temporary Space

Related Courses

Privacy Notice

In order to provide you with the service requested we will need to retain and use your contact information in accordance with our Privacy Notice. If you choose to provide us with this information you explicitly consent to us using the information as necessary to provide the requested service to you. If you do not agree please do not proceed to request the service from us.

Marketing Permissions

Would you like to receive our newsletter and other information on products and services which we think will be of interest to you by email. We will always treat your information with care and in accordance with our Privacy Notice. You are free to withdraw this permission at any time.

 

We work with the best