Oracle Database 19c: Performance Management and Tuning

Cost $5000

Course Code
D107403GC10

Duration
5 days

Format
Live Virtual Class

What you will learn

  • 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 parameters

Benefits to You

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

Audience

  • Administrator
  • Database Administrator

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

Topics

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

Enroll for Oracle Database 19c: Performance Management and Tuning

Oracle Database 19c: Performance Management and Tuning

$5,000.00

Clear

Additional information

Schedules

May 24 2021 – May 28 2021 (5 days) 9:00 AM – 5:00 PM US-Pacific, Sep 27 2021 – Oct 1 2021 (5 days) 9:00 AM – 5:00 PM US-Eastern, Jan 17 2022 – Jan 21 2022 (5 days) 9:00 AM – 5:00 PM US-Eastern

Format

Live Virtual Class

Reviews

There are no reviews yet.

Be the first to review “Oracle Database 19c: Performance Management and Tuning”

Your email address will not be published. Required fields are marked *

No products were found matching your selection.

Follow-on Courses

Browse the suggested follow-on courses below and continue your training journey. We offer training in various learning formats, from instructor-led to virtual, so you can choose what works best for you. Get started by selecting a course to learn more.

No products were found matching your selection.

TOP
0