Oracle Database: Performance Management and Tuning/1Z0-064

Oracle Database: Performance Management and Tuning Certification Training Course Overview

Understudies make sense of how to use Oracle Database customized tuning features, for instance, SQL Tuning Advisor, SQL Access Advisor, Automatic Workload Repository and Automatic Database Diagnostic Monitor, and practice these tuning procedures. The course bases on the tuning tasks expected of a DBA: open tuning of SQL declarations, keeping up SQL clarification and movement execution, and tuning the Oracle Database Instance parts.

Audience

  • Administrator
  • Database Administrator

 

This course prepares you for Exam 1Z0-064.

Oracle Database: Performance Management and Tuning (40 Hours) Download Course Contents

Live Online Training Fee On Request
Group Training
06 - 10 Dec GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)
03 - 07 Jan GTR 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Weekend

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Buy Flexi For Only $99 (Online Training Re-imagined)

Course Modules

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
Prerequisites
  • 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 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
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
Download Course Contents

Request More Information

Course Prerequisites
  • Oracle Database Administration with working knowledge of Linux

After completion of this course, you will learn following topics:

  • Diagnose and tune regular Instance related execution issues
  • Use Enterprise Manager execution related pages to screen an Oracle database
  • Use the Oracle Database tuning procedure
  • Utilize database counsels to proactively tune an Oracle Database Instance
  • Use the devices dependent on the Automatic Workload Repository to tune the database
  • Diagnose and tune basic SQL related execution issues