Oracle Database Performance Tuning for Administrators

PT27141
Summary
In this course students will clearly define the various methodologies one can use to tune an Oracle Database. The course covers the various components of an Oracle Database where potential performance bottlenecks could occur and how to monitor and tune them. Throughout the course, students experience hands-on exercises in tuning a database.
Prerequisites
Oracle Database Administration or Oracle DBA experience.
Duration
4 Days/Lecture & Lab
Audience
Oracle Database Administrators (DBAs).
Topics
  • Database Tuning Overview
  • Database Architecture
  • Automatic Memory Management (AMM and ASMM)
  • Tuning the Shared Pool
  • Tuning the Buffer Cache
  • Tuning PGA and Temporary Space
  • Checkpoint and Redo Tuning
  • Tuning Block Space Usage
  • Statistics and Wait Events
  • The Automatic Workload Repository (AWR) and the Advisory Framework
  • Additional SQL Tuning Topics
  • Oracle 18c New Features
  • Miscellaneous Tuning Tips

Related Scheduled Courses