Performance Tuning Training

What is Performance Tuning?

Performance tuning is the rectification of system performance. Normally, the computer systems motive the performance problem that can be anticipated. Performance tuning is modify the system to handle a higher load and Using some techniques to improve performance. Among them are load balancing,self-tuning,distributed computing ,code optimization and bottleneck.

Course Features

Duration60 hours
Skill levelAll leval
Batch Strength15
AssessmentsYes
Mock InterviewsYes
Resume BuildingYes
PlacementsYes
Flexible TimingYes
Fee InstallmentsYes
LanguageTamil/English

Section 1 : Performance Tuning Overview

Introduction to Perfomance Tuning Features and tools
How to set the performance goals?
Basic understanding of Oracle Architecture
Structure of Logical storages
Differences of logical and Physical Memory

Section 2 : Performance Designing and Developing

Main Phases of Data Design
Concepts of Data Model
System Architecture
Understand the Online transaction process
Performance tuning for Multi-purpose application

Section 3 : Optimizing SQL

What is physical retrieval of data?
Full Table Scan vs. Index scan performance
Overview of Performance Analytic Tools
Explain the Plan
SQL Tracing Facility
Tuning using Auto tracing
Join Procedures
Sort-Merge Join
Hash Joins
Nested Loops

Section 4 : Indexes

What is Indexes?
Understanding B-Tree indexes and how they impact the performance?
Using Bitmap index to tune the Oracle performance
Comparing Bitmap and B-Tree indexes
What is the use of Reverse key index?
When to use index organised tables?
Invisible indexes
How to create and monitor indexes

Section 5 : Metrics, Baseline and Alerts

Metrics, Alerts and Baseline Concepts
Limitation of Base Statistics tool
Advantage of Metrics
How to use Database control and setting the thresholds?
Histogram
Creating and Testing the Metrics, Alert and views

Impressed with our Course Content?
Attend a Free Demo Session to Experience our Quality!

Get Free Session

Section 6 : Automatic SQL Tuning

An Overview of Optimizer modes and its types
SQL Tuning Advisor
Using Dynamic Performance views

Section 7 : SQL Performance Analyzer

Explain the SQL Performance Analyzer process and benefits
How to use SQL Performance Analyzer

Section 8 : Tuning the Shared Pool

Understand the shared pool architecture and operations
The Library Cache & Latch and Mutex concepts
Overview of Diagnostic tools
Comparison of Soft Parse and Hard Parse
SQL Query Result cache and Data Dictionary cache
Tuning the large pool

Section 9 : Tuning the Buffer Cache

An Overview of Oracle database architecture – Buffer cache
What is Database Buffers?
Understand the Buffer hash table for lookups
Buffer Cache Performance Symptoms and Solutions

Section 10 : Using AWR-Based Tool

Introduction to Automatic Maintenance Tasks
Monitoring the ADDM Performance
Enhanced Automatic Workload Repository Views
Emergency Monitoring

Section 11 : Using Statspack

Installation of Statspack
Creating Statspack snapshots
How to generate the Statspack reports?
Statspack report Analysis

You will be going through detailed 2 to 3 months Performance Tuning Hands-on training

Detailed instructor led sessions to help you become a proficient Expert in Performance Tuning.
Build a Performance Tuning professional portfolio by working on hands on assignments and projects.
Personalised mentorship from professionals working in leading companies.
Lifetime access to downloadable Performance Tuning course materials, interview questions and project resources.

Credo Systemz - Velachery, Chennai
Call Us +91 9884412301

Credo Systemz - OMR, Chennai
Call Us +91 9600112302

Check here for candidates feedback on Performance Tuning Training through

Performance Tuning Training