Skip To Content
Oracle Database 12c: Performance Management and Tuning is a Program

Oracle Database 12c: Performance Management and Tuning

Self-paced

Sorry! The enrollment period is currently closed. Please check back soon.

Full program description

Oracle Database 12c: Performance Management and Tuning

Course Overview

In the course, 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, you will be introduced to Oracle Database Cloud Service.

Who Should Attend

  • Administrator
  • Database Administrator

Course Duration

5 Days, 35 Hours

Course Outline

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

Course Objectives

  • 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
  • Gain an understanding of the Oracle Database Cloud Service

Pre-requisites

Suggested Prerequisite

  • Oracle Database 12c: Install and Upgrade Workshop Ed 1

Price

Course Fee (before GST): SGD 4920.00

Course Fee (after GST): SGD 5264.40

ODB12PM