Remote Course for Oracle Database 19c: SQL Tuning Workshop | Certificated Course

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

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

Our students for 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

Contact

Course info

Classes

40

Delivery method

Online

Language

English

Price

€690 EUR

Payment method Request a callback

Course Application

Oracle Database 19c: SQL Tuning Workshop

Your Details

First Name * Last Name * E-mail * Phone * Country * City *

Who is the payment made for? Personal For a company For another person

Name and surname of the person being paid

Company Informations

Company Name Address

Number of employees Number of attendees

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

Request a callback

Oracle Database 19c: SQL Tuning Workshop

Еден чекор поблиску до посакуваната цел

Име на курс

Payment Method

Payment with credit cards

Payment via invoice