Om kurset

Oracle Database 18c DBA Performance Tuning & Management Course Overview

This Oracle Database 18c DBA Performance Tuning & Management course introduces the DBA to the main concepts of Oracle Database performance tuning and management. DBAs will gain practical experience in analyzing and tuning database performance.

Delegates on the Oracle Database 18c DBA Performance Tuning & Management course will learn how to use tuning goals and methodologies to identify tuning contentions in an Oracle database and how to take corrective action,how to detect and tune common database performance problems,how to use the database advisors to proactively tune a database and how to use the various tools provided by Oracle to tune a database.

Similarly,the course is targeted to closely follow the official Oracle Database curriculum for certification.

Exercises and examples are used throughout the course to give practical hands-on experience with the techniques covered.

Versions supported 12cR2,18c,19c.

Dette lærer du

Course Objectives

The objective of the Oracle Database 18c DBA Performance Tuning & Management course is to provide the skills needed to monitor and tune an Oracle Database.

Kursinnhold

Kurset dekker blant annet følgende temaer:

Oracle Database 18c DBA Performance Tuning & Management Training Course
Course Contents - DAY 1
Course Introduction
Session 1: INTRODUCTION TO ORACLE PERFORMANCE TUNING
Session 2: TOOLS FOR EVALUATING SQL STATEMENTS
Session 3: THE SQL OPTIMIZER
Session 4: SORTS
Session 5: INDEXES
Course Contents - DAY 2
Session 6: ADVANCED INDEXES
Session 7: JOIN OPERATIONS
Session 8: SQL TUNING ADVISOR USING SQL DEVELOPER
Session 9: SEQUENCES AND VIEWS
Session 10: USING HINTS
Session 11: MISCELLANEOUS
Course Contents - DAY 3
Session 12: BASIC TUNING DIAGNOSTICS
Session 13: REDUCE THE COST OF SQL OPERATIONS
Session 14: THE SQL PERFORMANCE ANALYZER
Session 15: SQL PERFORMANCE MANAGEMENT
Session 16: AUTOMATIC MEMORY MANAGEMENT
Session 17: TUNE THE SHARED POOL
Course Contents - DAY 4
Session 18: TUNE THE BUFFER CACHE
Session 19: TUNE PGA AND TEMPORARY SPACE
Session 20: CREATE AND USE SNAPSHOTS AND BASELINES WITH THE AUTOMATIC WORKLOAD REPOSITORY
Session 21: USE AWR-BASED TOOLS
Session 22: USE METRICS AND ALERTS
Course Contents - DAY 5
Session 23: REAL TIME DATABASE OPERATION MONITORING
Session 24: MONITOR APPLICATIONS
Session 25: BIG DATA AND DATA WAREHOUSE FEATURES
Session 26: TUNE DATABASE I/O
Session 27: A SUMMARY OF ORACLE PERFORMANCE TUNING

Forkunnskaper

Requirements

Delegates who wish to attend the Oracle Database 18c DBA Performance Tuning & Management course should have practical knowledge of using SQL and administering an Oracle database. They should have attended the Oracle SQL and the Oracle Database 18c Administration course or have a good working knowledge of Oracle SQL and Oracle database administration. The ability to describe and use Oracle built-in packages would be highly advantageous but is not essential.

This course is run on a Linux operating system,a basic knowledge of Linux/UNIX is recommended but is not essential.

Where Oracle 19c courses are listed in pre-requisites or follow-on courses the equivalent Oracle 18c or Oracle 12cR2 courses would also suffice.

Hvem passer kurset for?

Who will the Course Benefit?

The Oracle Database 18c DBA Performance Tuning & Management course is suitable for database administrators and technical support staff who are required to monitor and tune an Oracle database.

Videre kurs

Further Learning

Oracle Database 19c Backup and Recovery with RMAN
Oracle Database 19c Data Guard
Oracle Database 19c RAC and Grid Infrastructure Administration
Oracle Multitenant Administration

Kommende kurs

Kursdatoer

Viser 2 av 2

28.09.2026

NOK 39.000

14.12.2026

NOK 39.000

SG Partner

Hvorfor velge SG Partner?

Vi gjør det enkelt å finne riktig kurs og riktig gjennomføring for deg og din virksomhet.

Offisielle kurs

Kursinnhold fra anerkjente teknologileverandører og fagmiljøer.

Erfarne instruktører

Praktisk og faglig undervisning med fokus på kompetanse du kan bruke.

Fleksibel gjennomføring

Velg mellom tilgjengelige virtuelle, fysiske og bedriftsinterne kurs.

Personlig rådgivning

Vi hjelper deg med å finne kurs og kompetanseløp som passer behovet ditt.

FAQ

Ofte stilte spørsmål

Hvor lenge varer kurset?

Kursets oppgitte varighet er 5.

Kan jeg ta en sertifisering?

Kurset kan være relevant som forberedelse til sertifisering. Se kursbeskrivelsen for informasjon om aktuell sertifisering og eksamen.

Hvilke forkunnskaper trenger jeg?

Requirements Delegates who wish to attend the Oracle Database 18c DBA Performance Tuning & Management course should have practical knowledge of using SQL and administering an Oracle database. They should have attended the Oracle SQL and the Oracle Database 18c Administration course or have a good working knowledge of Oracle SQL and Oracle database administration. The ability to describe and use Oracle built-in packages would be highly advantageous but is not essential. This course is run on a Linux operating system,a basic knowledge of Linux/UNIX is recommended but is not essential. Where Oracle 19c courses are listed in pre-requisites or follow-on courses the equivalent Oracle 18c or Oracle 12cR2 courses would also suffice.

Hvem passer kurset for?

Who will the Course Benefit? The Oracle Database 18c DBA Performance Tuning & Management course is suitable for database administrators and technical support staff who are required to monitor and tune an Oracle database.

Kan kurset leveres som bedriftsinternt kurs?

Ja.

Hvor kan kurset leveres?

Kurset kan leveres over hele Norge, blant annet i Oslo, Kristiansand, Stavanger, Bergen, Trondheim og Tromsø.