Skip to Main Content
DBA Essentials - Monitor and Tune Oracle Database 21c

About This Workshop

Youtube Video

About This Workshop
This workshop enables you to monitor the workshop and identify performance-related issues in Oracle Database. You can configure SQL Tuning Advisor to improve the performance of high-load SQL statements.

Workshop Info

1 hour, 36 minutes
  • Lab 1: Prepare Setup
    This lab will show you how to download the Oracle Resource Manager (ORM) stack zip file needed to setup the resource needed to run this workshop.
  • Lab 2: Setup Compute Instance
    This lab shows you how to setup a Resource Manager stack.
  • Lab 3: Initialize environment
    This lab reviews all components required to run the workshop.
  • Lab 4: Monitor the state of Oracle Database
    This lab walks you through the procedure to monitor the state and workload of your Oracle Database.
  • Lab 5: Diagnose problems and improve performance using Automatic SQL Tuning Advisor
    This lab shows the steps for diagnosing problems in Oracle Database 21c and improving performance using Automatic SQL Tuning Advisor.
  • Familiar with local shell environments and commands (bash, c shell, etc.)
  • Comfortable executing commands in SQL prompt
  • Comfortable with web browsers
  • Familiarity with Oracle Database is desirable, but not required
  • Some understanding of database terms is helpful

Other Workshops you might like