TRAINING CATEGORIES
(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 15 April 2024 5 Days Istanbul Registration Form Link
IT-D 236 20 May 2024 5 Days Istanbul Registration Form Link
IT-D 236 24 June 2024 5 Days Istanbul Registration Form Link
IT-D 236 29 July 2024 5 Days Istanbul Registration Form Link
IT-D 236 02 September 2024 5 Days Istanbul Registration Form Link
IT-D 236 07 October 2024 5 Days Istanbul Registration Form Link
IT-D 236 11 November 2024 5 Days Istanbul Registration Form Link
IT-D 236 16 December 2024 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