fbpx

Oracle Courses

Oracle Database 11g: Performance Tuning

19
overview
Topics
Prerequisites
Objectives
Certification
overview

In this course, you will learn how to use Oracle Database 11g 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 performance, and tuning the Oracle Database Instance components.

 

Throughout the course, you will practice the art of tuning an Oracle Instance through a series of workshops.  It will also make use of many features that require the Enterprise Edition and optional Packs.

Topics
  • Introduction
  • Monitoring With Basic Tools
  • Using Automatic Workload Repository
  • Identifying the Problem
  • Identifying Problem SQL Statements
  • Influencing the Optimizer
  • SQL Plan Management
  • Change Management
  • Using Metrics and Alerts
  • Using AWR Based Tools
  • Monitoring an Application (Using Services)
  • Baselines
  • Tuning the Shared Pool
  • Tuning the Buffer Cache
  • Tuning PGA and Temporary Space
  • Automatic Memory Management
  • Tuning Block Space Usage
  • Tuning I/O,: Performance Tuning: Summary,Using Statspack
Prerequisites

Suggested Prerequisite

  • Oracle Database: SQL and PL/SQL Fundamentals

 

Required Prerequisite

  • Oracle Database 11g: Administration Workshop II
  • Oracle Database 11g: Administration Workshop I
Objectives

You will learn how to:

  • Use Database Statistics and Metrics to identify a performance problem
  • Interpret Tuning diagnostics
  • Identify and eliminate performance issues
  • Set tuning priorities and strategies
  • Identify problem SQL statements
  • Influence the optimizer
Certification

This course prepares you for the following Certifications

  • Oracle Database 11g Administrator Certification

Programme

At Institute of Software Technologies, we have flexible training schedule that suit your availability.

You can choose from the following available options:

FLY me a trainer

We have conducted onsite trainings for corporate clients all over the world including in over 100 companies in Kenya, Uganda, Tanzania, Rwanda, Zambia, Somalia, Ethiopia, South Sudan, Zanzibar, Malawi, Mozambique, Ghana, Nigeria, Sierra Leone, just to mention a few. References can be provided on request.

Fly me a Trainer is no different from classroom training, since it consists of the same setup. The only difference is that the trainer travels instead of the participants.

Apply Now For Our Next Intake

Website Enquiry

Relative Courses

Programing

SQL Fundamentals

SUSE Linux

Server Administration

Cloud computing

VMware – Foundation Course

Cyber Security

Certified Chief Information Security Officer (CCISO)

Administration

0 student
Cyber Security

EC-council Certified Security Analyst (ECSA)

Developer

0 student
Cloud computing

VMware Data Center Virtualization Course

Programing

PL/SQL

Graphic Design

Dreamweaver

Graphic Design

Flash Professional

ICDL

0 student
Graphic Design

Adobe Photoshop

Programing

ZEND PHP

Oracle Database 12c R2: Program with PL/SQL Ed 2

0 student

Application Developer

0 student

Oracle Database 12c: Backup & Recovery Workshop

0 student

EBusiness Suit

0 student
Programing

PHP

Cyber Security

Computer Hacking Forensic Investigator Certification

Oracle Courses

Oracle Database 11g: Administration Workshop I

UNIX and Linux Essentials

0 student

E-Business Suite Financial Management Training and Certification

0 student

Oracle Cash Management Fundamentals

0 student

Oracle E-Business Tax Fundamentals

0 student
Cyber Security

Licensed Penetration Tester (LPT)

Oracle General Ledger Management Fundamentals

0 student

Oracle Inventory Management Fundamentals

0 student
Graphic Design

Adobe Illustrator

Oracle iProcurement Fundamentals

0 student
Oracle Courses

Oracle Database 11g: Administration Workshop II

Oracle Order Management Fundamentals

0 student

Oracle Purchasing Fundamentals

0 student

Oracle Receivables Management Fundamentals

0 student

R12.2 Oracle Asset Management Fundamentals

0 student
Graphic Design

Adobe InDesign

R12.2 Oracle Subledger Accounting Fundamentals

0 student

R12.x Oracle Payables Management Fundamentals

0 student

Cisco CCNA Routing and Switching ICND I

0 student

Programming

0 student

Interconnecting Cisco Networking Devices, (ICND2)

0 student
Programing

HTML & CSS

0 student
ICDL

Corel Draw

ITIL Intermediate Module – Service Strategy

0 student

ITIL Intermediate Module – Service Strategy

0 student
Cyber Security

Certified Network Defender Certification (CND)

ITIL Practitioner Certification

0 student

The ITIL Intermediate Service Lifecycle: Continual Services Improvement Certificate

0 student
ICDL

ICDL Certification

The ITIL Intermediate Service Lifecycle: Service Operation

0 student

The ITIL Intermediate Service Lifecycle: Service Transition

0 student

CompTIA A+

0 student

Mobile App Development

0 student
Project Management

Prince 2 Training

Diplomas

0 student

Administering a SQL Database Infrastructure (2016)

0 student
Programing

Core Java

Oracle Courses

Introduction to SQL

Developing SQL Databases (2016)

0 student

Implementing a SQL Data Warehouse (2016)

0 student

PRINCE2® Foundation

0 student

PRINCE2® Practitioner

0 student

J2EE Architecture & JSP

Graphic Design

Graphic Design

0 student

COMPTIA

0 student

COMPTIA

0 student
Oracle Courses

Oracle Database 12c: Managing Multitenant Architecture

Programing

SQL / EJB&RM

Oracle Courses

Oracle Database 12c: Install and Upgrade Workshop

Oracle Courses

Data Modeling & Relational Database Design

Oracle Courses

Oracle 10g Forms Developer: Build Internet Apps

Security

0 student
Oracle Courses

Oracle Reports Developer 10g: Build Reports

Microsoft

Administering Windows Server 2012

Android Application Development

RED HAT

0 student
Diploma Courses

Diploma in Database Administration & Application Development

Microsoft

Installing and Configuring Server

Diploma Courses

Diploma in Information Security & Ethical Hacking

Microsoft SQL Sever 2016

0 student

My SQL

0 student
Microsoft

Configuring Advanced Windows Server

Programing

Python

CCNA

0 student
Project Management

PRINCE 2 Foundation

Oracle Courses

Oracle Solaris 10 OS Part 1

Microsoft

Designing and Implementing a Server Infrastructure

Red Hat Training

System Administration III With RHCSA & RHCE

Red Hat Training

System Administration II With RHCSA

Red Hat Training

RHCSA Rapid Track

Red Hat Training

System Administration I

Oracle Courses

Oracle Solaris 10 OS Part 1

Oracle Courses

Oracle Solaris 10 OS Part 2

Microsoft

Implementing an Advanced Server Infrastructure

Prince2

0 student
Oracle Courses

Oracle Solaris 10 OS Essentials

VMware Courses

0 student
SUSE Linux

Linux Enterprise

Project Management

PRINCE2® TRAINING

0 student

AWS Courses

0 student

Oracle

0 student
CCNA

Cisco CCNA Routing and Switching ICND I

Cyber Security

Certified Ethical Hacker Certification (CEH)

CompTIA A+

CompTIA

0 student
SUSE Linux

SUSE Linux Enterprise 11 Administration