Title

DBA Essentials - Monitor and tune Oracle Database 23ai using Oracle Enterprise Manager

About Or Title

About This Workshop

Desc Long

This workshop introduces you to using Oracle Enterprise Manager Cloud Control (EM) for monitoring the performance of your Oracle Database 23ai instance and ensuring that it runs optimally. It analyzes the workload running on the database, identifies issues, and implements corrective actions. This workshop helps you to effectively diagnose performance problems using the automatic SQL Tuning Advisor.

Workshop Length

1 hour, 18 minutes

Outline

Introduction to monitoring and tuning Oracle Database
Monitor general state of Oracle Database
Diagnose problems and improve performance using SQL Tuning Advisor

Prerequisites

Familiar with shell terminals and commands (bash, c shell, etc.)
Comfortable executing commands in SQL prompt
Comfortable with web browsers
Familiar with Oracle Database and Oracle Enterprise Manager is desirable, but not required

Other Workshops you might like

DBA Essentials - Administer Oracle Database 23ai with Oracle Enterprise Manager

DBA Essentials - Administer Oracle Database 23ai with Oracle Enterprise Manager

Explore container details from the SQL prompt. Manage target Oracle Databases and Listeners in a (..)

1 hr, 45 mins 517 Views
DBA Essentials - DB Admin with Oracle Enterprise Manager Cloud Control

DBA Essentials - DB Admin with Oracle Enterprise Manager Cloud Control

Do you want to view container details and start up Oracle EM? Do you want to learn how to manage (..)

1 hr, 45 mins 11898 Views
DBA Essentials Workshops Series for Oracle Database 21c

DBA Essentials Workshops Series for Oracle Database 21c

Check out the DBA Essentials workshops for Oracle Database 21c and learn the fundamentals of Oracle (..)

30 mins 2459 Views
DBA Essentials - Manage user accounts and security for Oracle Database 21c

DBA Essentials - Manage user accounts and security for Oracle Database 21c

Learn how to administer user accounts, roles, and system privileges with Oracle Enterprise Manager.

1 hr, 30 mins 6027 Views