Oracle Database 12c: Performance Management and Tuning Training

Overview
Course Content
Drop us a Query

Oracle Database 12c: Performance Management and Tuning training delivers all the essential skills and knowledge that a proactive DBA must possess. The detailed study in this course explains how to tune the database and conduct performance analysis. The candidates will be exposed to the right use of Enterprise Manager for monitoring the instances and related components. The upcoming and enthusiastic DBA’s will also develop the skills of identifying the SQL statements that need to be diagnosed and tuned. The training prepares the participants to appear for Oracle 12c performance tuning certification examination.

After learning Oracle Database 12c: Performance Management and Tuning course, the learners will be able to:

Understand the concept of tuning, Performance Tuning Diagnostics, and Performance Tuning Tools and related terms
Use Enterprise Manager, a tool based on the Automatic Workload Repository to tune the databases
Use metrics, alerts, and baselines to monitor the performance
Define use-cases and work on Real-time database operation monitoring
Control the behavior of the Query Optimizer with parameters
Tune instance components

Target audience

Database Administrators
Data Warehouse Administrators

Prerequisites

Oracle Database 12c: Install and Upgrade Workshop

Exam(s)

To be an Oracle Certified Expert, Oracle Database 12c: Performance Management and Tuning the candidate has to write and successfully qualify the exam 1Z0-064.

1. Introduction

Course Objectives
Course Organization
Course Agenda
Topics Not Included in the Course
Who Tunes?
What Does the DBA Tune?
How to Tune
Tuning Methodology

2. Basic Tuning Diagnostics

Performance Tuning Diagnostics
Performance Tuning Tools
Tuning Objectives
Top Timed Events
DB Time
CPU and Wait Time Tuning Dimensions
Time Model
Dynamic Performance Views

3. Using Automatic Workload Repository

Automatic Workload Repository Overview
Automatic Workload Repository Data
Enterprise Manager Cloud Control and AWR
Snapshots
Reports
Compare Periods

4. Defining the Scope of Performance Issues

Defining the Problem
Limiting the Scope
Setting the Priority
Top SQL Reports
Common Tuning Problems
Tuning During the Life Cycle
ADDM Tuning Session
Performance Versus Business Requirements

5. Using Metrics and Alerts

Metrics and Alerts Overview
Limitation of Base Statistics
Benefits of Metrics
Viewing Metric History Information
Viewing Histograms
Server-Generated Alerts
Setting Thresholds
Metrics and Alerts Views

6. Using Baselines

Comparative Performance Analysis with AWR Baselines
Automatic Workload Repository Baselines
Moving Window Baseline
Baselines in Performance Page Settings
Baseline Templates
AWR Baseslines
Creating AWR Baselines
Managing Baselines with PL/SQL

7. Using AWR-Based Tools

Automatic Maintenance Tasks
ADDM Performance Monitoring
Using Compare Periods ADDM
Active Session History
New or Enhanced Automatic Workload Repository Views
Emergency Monitoring
Real-time ADDM

8. Real-Time Database Operation Monitoring

Overview
Use Cases
Defining a Database Operation
Scope of a Composite Database Operation
Database Operation Concepts
Identifying a Database Operation
Enabling Monitoring of Database Operations
Identifying, Starting, and Completing a Database Operation

9. Monitoring Applications

What is a Service?
Service Attributes
Service Types
Creating Services
Managing Services in a Single-Instance Environment
Where are Services Used?
Using Services with Client Applications
Services and Pluggable Databases

10. Identifying Problem SQL Statements

SQL Statement Processing Phases
Role of the Oracle Optimizer
Identifying Bad SQL
Top SQL Reports
SQL Monitoring
What is an Execution Plan?
Methods for Viewing Execution Plans
Uses of Execution Plans

11. Influencing the Optimizer

Functions of the Query Optimizer
Selectivity
Cardinality and Cost
Changing Optimizer Behavior
Optimizer Statistics
Extended Statistics
Controlling the Behavior of the Optimizer with Parameters
Enabling Query Optimizer Features

12. Reducing the Cost of SQL Operations

Reducing the Cost
Index Maintenance
SQL Access Advisor
Table Maintenance for Performance
Table Reorganization Methods
Space Management
Extent Management
Data Storage

13. Using SQL Performance Analyzer

Real Application Testing: Overview
Real Application Testing: Use Cases
SQL Performance Analyzer: Process
Capturing the SQL Workload
Creating a SQL Performance Analyzer Task
SQL Performance Analyzer: Tasks
Parameter Change
SQL Performance Analyzer Task Page

14. SQL Performance Management

Maintaining SQL Performance
Maintaining Optimizer Statistics
Automated Maintenance Tasks
Statistic Gathering Options
Setting Statistic Preferences
Restore Statistics
Deferred Statistics Publishing
Automatic SQL Tuning

15. Using Database Replay

Using Database Replay
The Big Picture
System Architecture
Capture Considerations
Replay Considerations: Preparation
Replay Considerations
Replay Options
Replay Analysis

16. Tuning the Shared Pool

Shared Pool Architecture
Shared Pool Operation
The Library Cache
Latch and Mutex
Diagnostic Tools for Tuning the Shared Pool
Avoiding Hard Parses
Reducing the Cost of Soft Parses
Sizing the Shared Pool

17. Tuning the Buffer Cache

Oracle Database Architecture: Buffer Cache
Buffer Cache: Highlights
Database Buffers
Buffer Hash Table for Lookups
Working Sets
Buffer Cache Tuning Goals and Techniques
Buffer Cache Performance Symptoms
Buffer Cache Performance Solutions

18. Tuning PGA and Temporary Space

SQL Memory Usage
Performance Impact
Automatic PGA Memory
SQL Memory Manager
Configuring Automatic PGA Memory
Setting PGA_AGGREGATE_TARGET Initially
Limiting the size of the Program Global Area (PGA)
SQL Memory Usage

19. Automatic Memory

Oracle Database Architecture
Dynamic SGA
Granule
Memory Advisories
Manually Adding Granules to Components
Increasing the Size of an SGA Component
Automatic Shared Memory Management: Overview
SGA Sizing Parameters: Overview

20. Performance Tuning Summary with Waits

Commonly Observed Wait Events
Additional Statistics
Top 10 Mistakes Found in Customer Systems
Symptoms

I agree to be contacted over mail.

Partners

A Few Things You'll Love!

Accredited Training Partner
Certified & Industry Experts Trainers
Multiple Training Delivery Models
Customize course
24/7 e-Learning Access
Assessments and Mock Tests
Advance Analytical Reports
Placement Assistance

Related Courses

What our Students Speak

View All Testimonials

I would like to thank Multisoft team for their constant support and help that they extended during my study period. I gained proficiency in planning, initiation, closing, and execution, and now I am moderately proficient in monitoring and controlling process groups and cleared my PMP exam on 30th May. I am thankful to Multisoft for the same. I would like to especially thank the Training Advisor for the constant support, as all my queries were answered properly. Also, the sessions were arranged to clarify doubts, along with the mock test sessions.

It as been a wonderful experience learning Primavera from Multisoft Systems. I got training from an expert trainer who holds great command over the course. He delivered Primavera training with full enthusiasm and dedication, that helped me gain confidence over the software. He undertook each and every topic in a well regulated manner, covering all the aspects of Primavera. He was patient in clearing the doubts which came along the learning way.

Multisoft Systems is a one-stop solution for different learning requirements. I had gone for multiple trainings here back to back in the field of Electronics. Multisoft is a pool of excellent trainers, who are domain expert and knows well how to drive the class by encouraging the students to participate and learn more.

Initially I was hesitant to go for HTML, CSS, and PHP training. Although the Internet offers a lot of content, but there exists a gap in learning and practicing. On enrolling for PHP training at Multisoft Systems, I got all what I was looking for. My trainer was willing to provide me all the support required to to answer the my queries. I guarantee that such assistance is not provided anywhere else in Delhi NCR. I would definitely recommend Multisoft Systems to all my peers because of the training course, so wonderful that covers all areas of programming and web designing are fulfilled. I will always remember this training as it lifted me to a level where I can be independent in understanding computer languages.

The trainer is very knowledgeable and friendly. He promptly responded to all my queries and supported the answer with several relevant and related examples. All the queries were addressed with no delay and the course content was very good. Thanks a lot to the trainer and Multisoft!

It was really a very valuable and good training. The trainer was well versed with the subject and provided very effective training to the participants. The feedback was really appreciable. After the course, the participants were benefitted very much.

Attending CEH training at Multisoft Systems fulfills my objective completely. Training starting from the basics of networking to the advanced level of hacking skills gives me great exposure to the ethical hacking domain. Now, I’m confident enough to meet the security talent crisis of my organization.

I would say the skills and knowledge of the trainer were excellent. His way of teaching was also good. He always ensures that students should understand the concept and try to teach in the way which is easy to grasp the concepts. He was supportive in clearing the doubts throughout the classes.

Great training experience at Multisoft. The trainer with a highly practical approach makes the training very informative and interesting. His interpersonal skills make me feel comfortable in the sessions. Good place to take up SAS training.

I would like to thank you and your team for providing me "CBAP Exam Prep Training Workshop" successfully. I really appreciate everyone for being so responsive, professional and kind enough to help me in all aspects. The training happened remotely, however I really did not get the feel of distance gap. The trainer helped me to related the course concepts with the IT industry that honed my creative thinking skills.
Thank you to everyone.

Attending RHCSA training from Multisoft Systems was a complete package of learning, fun, and problem solving. I appreciate the teaching style of the trainer and his involvement into sessions.
I’m sure Multisoft Systems can be the right training destination for training on any technology.

Multisoft Systems team is great in providing visionary counseling. I’m highly benefited and can recommend my friends and others to once visit Multisoft Systems before closing any training related decision. I attended both Base SAS and Advance SAS trainings. The trainer was an expert in his domain and solved all my queries in a very satisfactory manner. The study material provided here helps me to a great extent in preparing for the examination and qualifying it in the first attempt only. Now I’m on the way to my dream job

Multisoft Systems is a good organization providing specialized training in all the demanding technologies and management areas. I attended ITIL® training for clearing the certification exam. I’m thankful to the trainer for imparting quality training. I congratulate Multisoft Systems for maintaining the standards in training.