Oracle Database: Performance Management and Tuning Training

  • Learn via: Virtual/Classroom
  • Duration: 5 Days
  • We can host this training at your preferred location. Contact us!
Upcoming Training

21 June 2021

5 Days

  • Use the Oracle tuning methodology
  • Use Oracle-supplied tools for monitoring and diagnosing SQL and instance tuning issues
  • Use database advisors to proactively correct performance problems
  • Identify problem SQL statements
  • Tune SQL performance problems
  • Monitor instance performance by using Enterprise Manager
  • Tune instance components by primarily using instance parameter

Audience

  • Administrator
  • Database Administrator

Suggested Prerequisite
  • Oracle Database 12c R2: Install and Upgrade Workshop Ed 2
  • Familiarity with Oracle Database installation
  • Familiarity with Oracle Database configuration concepts
Required Prerequisite
  • Oracle Database 18c: Administration Workshop Ed 1
  • Basic knowledge of Linux operating system
  • A working knowledge of SQL and PL/SQL packages
  • Basic understanding of Oracle Database architecture
  • Familiarity with basic database monitoring procedures

  • Use the Oracle Database tuning methodology appropriate to the available tools
  • Utilize database advisors to proactively tune an Oracle Database Instance
  • Use the tools based on the Automatic Workload Repository to tune the database
  • Diagnose and tune common SQL related performance problems
  • Diagnose and tune common Instance related performance problems
  • Use Enterprise Manager performance-related pages to monitor an Oracle Database

  • Introduction
  • Defining the Scope of Performance Issues
  • Using AWR-Based Tools
  • Identifying Problem SQL Statements
  • Using SQL Performance Analyzer
  • Tuning the Shared Pool
  • Automatic Memory
  • Basic Tuning Diagnostics
  • Using Metrics and Alerts
  • Real-Time Database Operation Monitoring
  • Influencing the Optimizer
  • SQL Performance Management
  • Tuning the Buffer Cache
  • Performance Tuning Summary with Waits
  • Using Automatic Workload Repository
  • Using Baselines
  • Monitoring Applications
  • Reducing the Cost of SQL Operations
  • Using Database Replay
  • Tuning PGA and Temporary Space


Contact us for more detail about our trainings and for all other enquiries!

Upcoming Trainings

Join our public courses in our Istanbul, London and Ankara facilities. Private class trainings will be organized at the location of your preference, according to your schedule.

21 June 2021
5 Days
Classroom / Virtual Classroom

Istanbul, Ankara, London
24 June 2021
5 Days
Classroom / Virtual Classroom

Istanbul, Ankara, London
20 July 2021
5 Days
Classroom / Virtual Classroom

Istanbul, Ankara, London
25 July 2021
5 Days
Classroom / Virtual Classroom

Istanbul, Ankara, London
02 August 2021
5 Days
Classroom / Virtual Classroom

Istanbul, Ankara, London
03 September 2021
5 Days
Classroom / Virtual Classroom

Istanbul, Ankara, London
15 September 2021
5 Days
Classroom / Virtual Classroom

Istanbul, Ankara, London
11 October 2021
5 Days
Classroom / Virtual Classroom

Istanbul, Ankara, London