(Click Category to List Courses)

38 - IT-D Information Technology - Databases and Related Technologies

IT-D 236 - Oracle Database 12c: Performance Management and Tuning

Code Start Date Duration Venue
IT-D 236 09 October 2023 5 Days Istanbul Registration Form Link
IT-D 236 04 December 2023 5 Days Istanbul Registration Form Link
Please contact us for fees


Course Description

In the Oracle Database 12c: Performance Management and Tuning course, participants will learn about the performance analysis and tuning tasks expected of a DBA: proactive management through built-in performance analysis features and tools, diagnosis and tuning of the Oracle Database instance components, and diagnosis and tuning of SQL-related performance issues. In this course, they will be introduced to Oracle Database Cloud Service.

Course Objectives

  • Using the Oracle tuning methodology
  • Using Oracle-supplied tools for monitoring and diagnosing SQL and instance performance issues
  • Using database advisors to proactively correct performance problems
  • Identifying and tune problem SQL statements
  • Monitoring instance performance by using Enterprise Manager
  • Tuning instance components
  • Gaining an understanding of the Oracle Database Cloud Service

Who Should Attend?

  • Programmers 
  • Database Administrators
  • Data Warehouse Administrators

Course Details/Schedule

Day 1

  • Basic Tuning Diagnostics
  • CPU and Wait Time Tuning Dimensions
  • Performance Tuning Diagnostics
  • Using Automatic Workload Repository
  • Defining the Scope of Performance Issues

Day 2

  • Using Metrics and Alerts
  • Using Baselines
  • Using AWR-Based Tools
  • Real-Time Database Operation Monitoring
  • Monitoring Applications

Day 3

  • Identifying Problem SQL Statements
  • Influencing the Optimizer
  • Reducing the Cost of SQL Operations
  • Using SQL Performance Analyzer

Day 4

  • SQL Performance Management
  • Using Database Replay
  • Tuning the Shared Pool
  • Tuning the Buffer Cache

Day 5

  • Tuning PGA and Temporary Space
  • Automatic Memory
  • Performance Tuning Summary with Waits
  • Oracle Database Cloud Service: Overview