Overview

Tune your databases with targeted queries and tuning methodology so you can identify problems before they arise.

Learn how to use advisors inside of an oracle database, as well as various tools provided by Oracle, in order configure the right settings for optimal performance. Gain skills in this Oracle database course to:

  • use targeted query tuning and methodology to identify tuning problems in an Oracle database to take corrective action
  • how to identify and tune a common database
  • troubleshoot performance issues
  • use advisors inside the database in order to understand in advance what settings need to be made and how to use the various tools provided by Oracle to configure the database

Skills Covered

After completing this course, you will be able 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

Who Should Attend

This course intended for Database administrators and technical support staff.

Course Curriculum

Prerequisites

  • Working knowledge of using SQL and administering an Oracle database 19c.
  • Basic knowledge of Linux / UNIX is recommended but not essential.

Download Syllabus

Course Modules

Request More Information