Home > Vendors > oracle > d79236

D79236 - Oracle Database 12c: Performance Management and Tuning

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.

Duration: 5.0 days

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

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

Audience

Database Administrators
Data Warehouse Administrator

Prerequisites

Oracle Database 12c R2: Administration Workshop Ed 3

Suggested Prerequisites:

Oracle Database 12c: Install and Upgrade Workshop

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

d83527

D83527 - Java SE 8 Fundamentals

d79995

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

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

Enquire Now

RfhVVh

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

➤