Oracle Database: Performance Management and Tuning - Fudgelearn

Oracle Database: Performance Management and Tuning

Date
Time
Price
04-May-2020
09:00 AM BST - 05:00 AM BST
£ 2495
11-May-2020
02:00 PM BST - 10:00 AM BST
£ 2495
18-May-2020
04:30 AM BST - 12:30 AM BST
£ 2495
01-Jun-2020
02:00 PM BST - 10:00 AM BST
£ 2495
27-Jul-2020
04:00 PM BST - 12:00 PM BST
£ 2495
28-Sep-2020
06:00 PM BST - 02:00 PM BST
£ 2495
19-Oct-2020
08:00 AM BST - 04:00 AM BST
£ 2495
26-Oct-2020
01:00 PM GMT - 09:00 AM GMT
£ 2495
Date
Time
Price
Location
13-Apr-2020
04:30 AM BST - 12:30 AM BST
£ 0
Live Virtual Class
04-May-2020
08:00 AM BST - 04:00 AM BST
£ 0
Stockholm
22-Jun-2020
02:00 AM BST - 10:00 PM BST
£ 0
Live Virtual Class
22-Jun-2020
07:00 AM BST - 03:00 AM BST
£ 0
Floriana
20-Jul-2020
03:00 AM BST - 11:00 PM BST
£ 0
Jakarta
03-Aug-2020
08:00 AM BST - 12:00 PM BST
£ 0
Lima
10-Aug-2020
09:00 AM BST - 05:00 AM BST
£ 0
Live Virtual Class
24-Aug-2020
02:00 AM BST - 10:00 PM BST
£ 0
Pasig City
13-Sep-2020
12:15 AM BST - 05:15 AM BST
£ 0
Amman
13-Sep-2020
08:00 AM BST - 04:00 AM BST
£ 0
Live Virtual Class
14-Sep-2020
02:00 PM BST - 10:00 AM BST
£ 0
Toronto
20-Sep-2020
08:00 AM BST - 04:00 AM BST
£ 0
Cairo
21-Sep-2020
02:00 AM BST - 10:00 PM BST
£ 0
Petaling Jaya
16-Nov-2020
02:00 PM GMT - 10:00 AM GMT
£ 0
Edison
16-Nov-2020
02:00 PM GMT - 10:00 AM GMT
£ 0
King of Prussia
Date
Start time
Price
Location
Version title
Price
  • 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

 

 

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
  • Administrator
  • Database Administrator
  • 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
  • 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
Need help finding the right course

Having problem finding the course you’re looking for? Get in touch.

£ 2495
5 Days
Live Virtual Class
8 Events available
5 Days
Live Virtual Class
15 Events available
Share this Course
Get in touch
If you would like to find out how we can help you, please get in touch
Book a meeting
We offer free consultation if you’re keen to find out what course fits the best for you. Use the link below to schedule a meeting with us.
Print
Use the links below to print the details.
Convince your boss

Oracle Database: Performance Management and Tuning

Course Overview

  • 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

 

 

Virtual Class
5 Days
Date
Start time
Price
Location
04-May-2020
09:00 AM BST
£ 2495
Live Virtual Class
11-May-2020
02:00 PM BST
£ 2495
Live Virtual Class
18-May-2020
04:30 AM BST
£ 2495
Live Virtual Class
01-Jun-2020
02:00 PM BST
£ 2495
Live Virtual Class
27-Jul-2020
04:00 PM BST
£ 2495
Live Virtual Class
28-Sep-2020
06:00 PM BST
£ 2495
Live Virtual Class
19-Oct-2020
08:00 AM BST
£ 2495
Live Virtual Class
26-Oct-2020
01:00 PM GMT
£ 2495
Live Virtual Class
Classroom
5 Days
Date
Start time
Price
Location
13-Apr-2020
04:30 AM BST
£ 0
Live Virtual Class
04-May-2020
08:00 AM BST
£ 0
Stockholm
22-Jun-2020
02:00 AM BST
£ 0
Live Virtual Class
22-Jun-2020
07:00 AM BST
£ 0
Floriana
20-Jul-2020
03:00 AM BST
£ 0
Jakarta
03-Aug-2020
08:00 AM BST
£ 0
Lima
10-Aug-2020
09:00 AM BST
£ 0
Live Virtual Class
24-Aug-2020
02:00 AM BST
£ 0
Pasig City
13-Sep-2020
12:15 AM BST
£ 0
Amman
13-Sep-2020
08:00 AM BST
£ 0
Live Virtual Class
14-Sep-2020
02:00 PM BST
£ 0
Toronto
20-Sep-2020
08:00 AM BST
£ 0
Cairo
21-Sep-2020
02:00 AM BST
£ 0
Petaling Jaya
16-Nov-2020
02:00 PM GMT
£ 0
Edison
16-Nov-2020
02:00 PM GMT
£ 0
King of Prussia
Prerequisites

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
Audience
  • Administrator
  • Database Administrator
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
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