✕

Hi i am SEM,
how can i help you

Hungry for knowledge?
Semos Education Semos Education
  • Monday - Friday 9:00 AM - 10:00 PM CET
  • Call us now +44 7487633466
  • Keep in touch info@semosedu.com
EN / МК / RS
EN / МК / RS
Reserve a seat
Кошничка
Вкупно €0 EUR
Кон кошничка
reserve a seat

Oracle Database 19c: SQL Tuning Workshop

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
Overview

 

MODULE 2
Defining the Scope of Performance Issues

 

MODULE 3

Using the Time Model to Diagnose Performance Issues

 

MODULE 4

Using Statistics and Wait Events to Diagnose Performance Issues

 

MODULE 5

Using Log and Trace Files to Monitor Performance

 

MODULE 6

Using Enterprise Manager Cloud Control and SQL Developer to Monitor Performance

 

MODULE 7

Using Statspack to View Performance Data

 

MODULE 8

Using Automatic Workload Repository

 

MODULE 9

Using Metrics and Alerts

 

MODULE 10

Using Baselines

 

MODULE 11

Managing Automated Maintenance Tasks

 

MODULE 12

Using ADDM to Analyze Performance

 

MODULE 13

Using Active Session History Data for First Fault System Analysis

 

MODULE 14

Using Emergency Monitoring and Real-Time ADDM to Analyze Performance Issues

 

MODULE 15

Overview of SQL Statement Processing

 

MODULE 16

Maintaining Indexes

 

MODULE 17

Maintaining Tables

 

MODULE 18

Introduction to Query Optimizer

 

MODULE 19

Understanding Execution Plans

 

MODULE 20

Viewing Execution Plans by Using SQL Trace and TKPROF

 

MODULE 21

Managing Optimizer Statistics

 

MODULE 22

Using Automatic SQL Tuning

 

MODULE 23

Using the SQL Plan Management Feature

 

MODULE 24

Overview of the SQL Advisors

 

MODULE 25

Using the SQL Tuning Advisor

 

MODULE 26

Using the SQL Access Advisor

 

MODULE 27

Overview of Real Application Testing Components

 

MODULE 28

Using SQL Performance Analyzer to Determine the Impact of Changes

 

MODULE 29

Using Database Replay to Test System Performance

 

MODULE 30

Implementing Real-Time Database Operation Monitoring

 

MODULE 31

Using Services to Monitor Applications

 

MODULE 32

Overview of Memory Structures

 

MODULE 33

Managing Shared Pool Performance

 

MODULE 34

Managing Buffer Cache Performance

 

MODULE 35

Managing PGA and Temporary Space Performance

 

MODULE 36

Configuring the Large Pool

 

MODULE 37

Using Automatic Shared Memory Management

 

MODULE 38

Introduction to In-Memory Column Store

 

MODULE 39

Configuring the In-Memory Column Store Feature

 

MODULE 40

Using In-Memory Column Store with Oracle Database Features

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

 

MODULE 2
Defining the Scope of Performance Issues

 

MODULE 3

Using the Time Model to Diagnose Performance Issues

 

MODULE 4

Using Statistics and Wait Events to Diagnose Performance Issues

 

MODULE 5

Using Log and Trace Files to Monitor Performance

 

MODULE 6

Using Enterprise Manager Cloud Control and SQL Developer to Monitor Performance

 

MODULE 7

Using Statspack to View Performance Data

 

MODULE 8

Using Automatic Workload Repository

 

MODULE 9

Using Metrics and Alerts

 

MODULE 10

Using Baselines

 

MODULE 11

Managing Automated Maintenance Tasks

 

MODULE 12

Using ADDM to Analyze Performance

 

MODULE 13

Using Active Session History Data for First Fault System Analysis

 

MODULE 14

Using Emergency Monitoring and Real-Time ADDM to Analyze Performance Issues

 

MODULE 15

Overview of SQL Statement Processing

 

MODULE 16

Maintaining Indexes

 

MODULE 17

Maintaining Tables

 

MODULE 18

Introduction to Query Optimizer

 

MODULE 19

Understanding Execution Plans

 

MODULE 20

Viewing Execution Plans by Using SQL Trace and TKPROF

 

MODULE 21

Managing Optimizer Statistics

 

MODULE 22

Using Automatic SQL Tuning

 

MODULE 23

Using the SQL Plan Management Feature

 

MODULE 24

Overview of the SQL Advisors

 

MODULE 25

Using the SQL Tuning Advisor

 

MODULE 26

Using the SQL Access Advisor

 

MODULE 27

Overview of Real Application Testing Components

 

MODULE 28

Using SQL Performance Analyzer to Determine the Impact of Changes

 

MODULE 29

Using Database Replay to Test System Performance

 

MODULE 30

Implementing Real-Time Database Operation Monitoring

 

MODULE 31

Using Services to Monitor Applications

 

MODULE 32

Overview of Memory Structures

 

MODULE 33

Managing Shared Pool Performance

 

MODULE 34

Managing Buffer Cache Performance

 

MODULE 35

Managing PGA and Temporary Space Performance

 

MODULE 36

Configuring the Large Pool

 

MODULE 37

Using Automatic Shared Memory Management

 

MODULE 38

Introduction to In-Memory Column Store

 

MODULE 39

Configuring the In-Memory Column Store Feature

 

MODULE 40

Using In-Memory Column Store with Oracle Database Features

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

Related Courses

  • Oracle Database: Data Guard Administration Workshop
    Contact Us 40 €1.176 EUR Read More
  • Oracle Database 19c: Performance Management and Tuning
    Contact Us 40 €1.210 EUR Read More
  • Oracle Database 12c: RAC Administration
    Contact Us 40 €1.176 EUR Read More

Contact

Course Application
Oracle Database 19c: SQL Tuning Workshop

Your Details

Who is the payment made for?

Company Informations

After submitting the application, you will be contacted by our sales persons.

Request a callback
Oracle Database 19c: SQL Tuning Workshop

Your Details

Еден чекор поблиску до посакуваната цел
Име на курс
Payment Method
Payment with credit cards Payment via invoice