Back to Previous

Oracle Database 19c: Performance Management and Tuning

ENDED

Online Training by DBQuest, Inc.

Inquire Now

Online / Training

Inquire for Price

Inquire Enroll Now

RESPONSE RATE

Details
Outline
About the Provider

Enroll Now

Inquire

Details

In the Oracle Database: 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 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

Prerequisites

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 procedure

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

Outline

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 OperationMonitoring
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

Reviews

Be the first to write a review about this course.

Write a Review

DBQuest, Inc. is an Oracle Training Provider and an Approved Training Partner of Lithan. We are one of the Authorized Training Center of Oracle University here in the Philippines with over 10 years of delivering high quality Education. Recently, we partners with Lithan, an eduCLaaS Digital Skills Accelator in Singapore to deliver International Degree Programs and Certification Skills Programs.

AWARDS AND RECOGNITIONS