Semos Education Semos Education
  • Monday - Friday 9:00AM - 10:00PM
  • Call us now +44 7487633466
  • Keep in touch info@semosedu.com
EN / МК / RS
Кошничка
reserve a seat
  • Description
  • Content
  • Target Audience
  • Benefits
  • Certificates

The Oracle Database 19c: Performance Management and Tuning course teaches you about the performance analysis and tuning tasks expected of a database administrator. The instructions are reinforced with hands-on practices.

MODULE 1

Introduction

 

MODULE 2

Basic Tuning Tools

 

MODULE 3

Using Automatic Workload Repository

 

MODULE 4

Defining Problems

 

MODULE 5

Using Metrics and Alerts

 

MODULE 7

Using Baselines

 

MODULE 8

Using AWR Based Tools

 

MODULE 9

Monitoring an Application

 

MODULE 10

Identifying Problem SQL Statements

 

MODULE 11

Influencing the Optimizer

 

MODULE 12

Using SQL Performance Analyzer

 

MODULE 13

SQL Performance Management

 

MODULE 14

Using Database Replay

 

MODULE 15

Tuning the Shared Pool

 

MODULE 16

Tuning the Buffer Cache

 

MODULE 17

Tuning PGA and Temporary Space

  • Administrator
  • Architect
  • Database Administrator

Benefits to you:

 

Demonstrate fluency in and strong understanding of Oracle Database 19c performance analysis, management, and tuning for optimal performance in a complex environment.

 

 

In this course, you will learn to:

 

  • Describe Performance Management
  • Use AWR Performance Statistics
  • Use AWR Based Tools
  • Improve SQL Statement Performance
  • Influence the Optimizer
  • Use Tuning Analyzers and Advisors
  • Monitor Operations and applications
  • Manage Memory
  • Manage Database Memory
  • Use In-Memory Column Store Feature

Course attendance certificate issued by Semos Education

Description

The Oracle Database 19c: Performance Management and Tuning course teaches you about the performance analysis and tuning tasks expected of a database administrator. The instructions are reinforced with hands-on practices.

Content

MODULE 1

Introduction

 

MODULE 2

Basic Tuning Tools

 

MODULE 3

Using Automatic Workload Repository

 

MODULE 4

Defining Problems

 

MODULE 5

Using Metrics and Alerts

 

MODULE 7

Using Baselines

 

MODULE 8

Using AWR Based Tools

 

MODULE 9

Monitoring an Application

 

MODULE 10

Identifying Problem SQL Statements

 

MODULE 11

Influencing the Optimizer

 

MODULE 12

Using SQL Performance Analyzer

 

MODULE 13

SQL Performance Management

 

MODULE 14

Using Database Replay

 

MODULE 15

Tuning the Shared Pool

 

MODULE 16

Tuning the Buffer Cache

 

MODULE 17

Tuning PGA and Temporary Space

Target Audience
  • Administrator
  • Architect
  • Database Administrator
Benefits

Benefits to you:

 

Demonstrate fluency in and strong understanding of Oracle Database 19c performance analysis, management, and tuning for optimal performance in a complex environment.

 

 

In this course, you will learn to:

 

  • Describe Performance Management
  • Use AWR Performance Statistics
  • Use AWR Based Tools
  • Improve SQL Statement Performance
  • Influence the Optimizer
  • Use Tuning Analyzers and Advisors
  • Monitor Operations and applications
  • Manage Memory
  • Manage Database Memory
  • Use In-Memory Column Store Feature
Certificates

Course attendance certificate issued by Semos Education

Past experiences

What people say about us

  • - Marko Krstevski Microsoft .NET Academy

    Seeking to expand my knowledge, I decided to enroll in Semos Education, where I am gaining the necessary knowledge and experience.

  • - Teodor Markovski Student

    The desire to become a Cloud architect led me to Semos Education. I am thrilled by the positive experiences of former students and the way in which the instructors and Career Center take care of the students.

  • - Viktorija Georgieva Summer Mentorship Program for Python Develope

    The reputation of Semos Education for quality training and the opportunity to learn from experienced instructors played an additional significant role in my decision.

  • - Borche Peltekovski Accredited Academy for Graphic Design

    After completing my studies at Semos Education, I envision myself working in a technology company, such as Samsung, Apple, or a company of similar caliber.

  • - Vasilija Uzunova Oracle Certified Instructor

    For me, there was no other choice but Semos Education. I want to be part of the best, I want to share my knowledge in a company that is global, and ours.

Meet the instructors

  • Biljana Barukchieva  

    Senior project manager

    @Quinshift

     

    20+ years of experience