Oracle Database Performance Management and Tuning

 

Students learn how to use Oracle Database automatic tuning features such as SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database Diagnostic Monitor, and practice these tuning methods. The course focuses on the tuning tasks expected of a DBA: reactive tuning of SQL statements, maintaining SQL statement and operation performance, and tuning the Oracle Database Instance components.

 

Learn To
  • 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 parameters 

 

Prerequisite

 

Suggested Prerequisite

  • Oracle Database: Deploy, Patch and Upgrade Workshop
  • Familiarity with Oracle Database installation
  • Familiarity with Oracle Database configuration concepts

Required Prerequisite

  • Oracle Database: Administration Workshop
  • 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
Audience
  • Administrator
  • Database Administrator
Course Objective
  • 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
Course Topics
  • 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

 

 

Contact Us

Oracle Database

{{value[0].Version}}

Oracle Training Schedule

Course Name Start Date Start Time Duration (days) Time Zone Instructor Language Delivery Method
Java EE 6: Develop Business Components with JMS  EJBs 17-Nov-2019 09:00 AM 4 Asia/Dubai en ILT
Java SE 8 Fundamentals 19-Jan-2020 09:00 AM 5 Asia/Dubai en ILT
Java SE 8 Fundamentals 10-May-2020 09:00 AM 5 Asia/Dubai en ILT
Java SE: Programming I 26-Jan-2020 09:00 AM 5 Asia/Dubai en ILT
Java SE: Programming I 5-Apr-2020 09:00 AM 5 Asia/Dubai en ILT
Java SE: Programming I 17-May-2020 09:00 AM 5 Asia/Dubai en ILT
Java SE: Programming II 2-Feb-2020 09:00 AM 5 Asia/Dubai en ILT
Java SE: Programming II 12-Apr-2020 09:00 AM 5 Asia/Dubai en ILT
Oracle Application Express Workshop I 9-Feb-2020 09:00 AM 5 Asia/Dubai en ILT
Oracle Application Express Workshop II 16-Feb-2020 09:00 AM 3 Asia/Dubai en ILT
Oracle Application Express: Administration 23-Feb-2020 09:00 AM 2 Asia/Dubai en ILT
Oracle Application Express: Administration 8-Mar-2020 09:00 AM 2 Asia/Dubai en ILT
Oracle BI 11g R1: Build Repositories 13-Oct-2019 09:00 AM 5 Asia/Dubai en ILT
Oracle BI 11g R1: Build Repositories 13-Oct-2019 09:00 AM 5 Asia/Dubai en ILT
Oracle BI 11g R1: Create Analyses and Dashboards 3-Nov-2019 09:00 AM 4 Asia/Dubai en ILT
Oracle BI 12c: Overview 29-Mar-2020 09:00 AM 1 Asia/Dubai en ILT
Oracle Big Data Fundamentals 17-Nov-2019 09:00 AM 5 Asia/Dubai en ILT
Oracle Database 11g: Administration Workshop I Release 2 8-Dec-2019 09:00 AM 5 Asia/Dubai en ILT
Oracle Database 11g: Administration Workshop II Release 2 27-Oct-2019 09:00 AM 5 Asia/Dubai en ILT
Oracle Database 11g: Administration Workshop II Release 2 24-Nov-2019 09:00 AM 5 Asia/Dubai en ILT
Oracle Database 12c R2: SQL Tuning for Developers Ed 2 10-Nov-2019 09:00 AM 3 Asia/Dubai en ILT
Oracle Fusion Middleware 11g: Administration Overview 5-Jan-2020 09:00 AM 5 Asia/Dubai en ILT
Oracle Fusion Middleware 11g: Administration Overview 29-Mar-2020 09:00 AM 5 Asia/Dubai en ILT
Oracle Fusion Middleware 11g: Administration Overview 24-May-2020 09:00 AM 5 Asia/Dubai en ILT
Oracle Fusion Middleware 11g: Build Applications with ADF Accelerated 12-Jan-2020 09:00 AM 5 Asia/Dubai en ILT
Oracle Fusion Middleware 11g: Build Applications with ADF Accelerated 29-Mar-2020 09:00 AM 5 Asia/Dubai en ILT
Oracle Linux 7: System Administration 25-Nov-2019 09:00 AM 5 Asia/Dubai en ILT
Oracle Linux System Administration I 2-Feb-2020 09:00 AM 5 Asia/Dubai en ILT
Oracle Solaris 11 Security Administration 2-Feb-2020 09:00 AM 5 Asia/Dubai en ILT
Oracle Solaris 11 Security Administration 26-Apr-2020 09:00 AM 5 Asia/Dubai en ILT
Oracle WebLogic Server 12c: Administration I 12-Jan-2020 09:00 AM 5 Asia/Dubai en ILT
Oracle WebLogic Server 12c: Administration II 2-Feb-2020 09:00 AM 5 Asia/Dubai en ILT
Oracle WebLogic Server 12c: Administration II 26-Apr-2020 09:00 AM 5 Asia/Dubai en ILT
Oracle WebLogic Server 12c: Performance Tuning Workshop 16-Feb-2020 09:00 AM 3 Asia/Dubai en ILT
Oracle WebLogic Server 12c: Troubleshooting Workshop 23-Feb-2020 09:00 AM 2 Asia/Dubai en ILT
Oracle WebLogic Server 12c: Troubleshooting Workshop 10-May-2020 09:00 AM 2 Asia/Dubai en ILT
Primavera P6 Professional Fundamentals Rel 17 27-Oct-2019 09:00 AM 3 Asia/Dubai en ILT
UNIX and Linux Essentials 24-Nov-2019 09:00 AM 3 Asia/Dubai en ILT
UNIX and Linux Essentials 22-Mar-2020 09:00 AM 3 Asia/Dubai en ILT
UNIX and Linux Essentials 17-May-2020 09:00 AM 3 Asia/Dubai en ILT

 

Contact Us For More Information