• +91 - 444 351 1623
  • Contact[at]traininginadyar.in
Best Software Training Institute in Chennai
Performance Tuning Training in Chennai

Performance Tuning Training in Chennai

Learn how to use Performance Tuning from beginner level to advanced techniques which is taught by experienced working professionals. With our Performance Tuning Training in Chennai you'll learn concepts in expert level with practical manner.

Performance tuning is one of the DBA's greatest challenges, with both tangible and less obvious rewards. DBA performs to identify problem areas diagnose common problems and fix them and maximize the utility of the database. The performance expert must use a process that adapts to the various stages of the tuning assignment. We are providing the high level real time training to handle the critical databases. The below course includes on overview of tuning, statspack, AWR, ADDM & ASH report generation, SQL Profile management, Tuning advisors and manage the baseline.

Upcoming Batches

Starts Duration Days Time (IST)
04th Nov 4 Weeks Mon – Fri 07:30AM – 09:00AM
07th Nov 6 Weeks Sat & Sun 09:00AM – 11:30AM
09th Nov 4 Weeks Mon – Fri 08:30AM – 10:00AM
11th Nov 4 Weeks Mon – Fri 08:00AM – 09:30AM
14th Nov 6 Weeks Sat & Sun 11:00AM – 1:30PM
16th Nov 4 Weeks Mon – Fri 07:00AM – 08:30AM
18th Nov 4 Weeks Mon – Fri 10:00AM – 11:30AM
21st Nov 6 Weeks Sat & Sun 12:30PM – 03:00PM
23rd Nov 4 Weeks Mon – Fri 08:30AM – 10:00AM
25th Nov 4 Weeks Mon – Fri 10:00AM – 11:30AM
28th Nov 6 Weeks Sat & Sun 12:30PM – 03:00PM
30st Nov 4 Weeks Mon – Fri 10:00AM – 11:30AM
10% EARLYBIRD OFF for December Batches (Expires on 29th Nov)
02nd Dec 4 Weeks Mon – Fri 10:00AM – 11:30AM
05th Dec 6 Weeks Sat & Sun 12:30AM – 03:00PM
07th Dec 4 Weeks Mon – Fri 07:00AM – 08:30AM
09th Dec 4 Weeks Mon – Fri 07:00AM – 08:30AM
Schedule does not suit you, contact us now! | Want to take one-on-one training, contact us now!


Oracle Database 11g: Performance Tuning


  • This lesson introduces the Performance Tuning course objectives and agenda

Performance Tuning Overview

  • Write appropriate tuning goals
  • Apply the tuning methodology
  • Identify common tuning problems
  • Log a performance Service Request with Oracle Support

Basic Tuning Tools

  • Monitoring tools overview
  • Enterprise Manager
  • V$ Views, Statistics and Metrics
  • Wait Events

Using Statspack

  • Install Statspack
  • Create Statspack snapshots
  • Generate Statspack reports
  • Identify the major sections of the Statspack report

Using Automatic Workload Repository

  • Managing the Automatic Workload Repository Create AWR Snapshots
  • Generate AWR reports
  • Create snapshot sets and compare periods
  • Generate ADDM reports
  • Generate ASH reports
  • Real Time SQL Monitoring

Using AWR Based Tools

  • Automatic Maintenance Tasks
  • ADDM Performance Monitoring
  • Active Session History
  • Defining Problems

    • Defining the Problem
    • Top SQL Reports
    • ADDM Tuning Session
    • Performance versus Business Requirements
    • Performance Tuning Resources & Filing a Performance Service Request

    Using Metrics and Alerts

    • Metrics, Alerts, and Baselines
    • Limitation of Base Statistics & Typical Delta Tools
    • Benefits of Metrics
    • Viewing Metric History Information & using EM to View Metric Details
    • Statistic Histograms & Histogram Views
    • Database Control Usage Model & Setting Thresholds

    Using Baselines

    • Comparative Performance Analysis with AWR Baselines
    • Automatic Workload Repository Baselines
    • Moving Window Baseline
    • Baselines in Performance Page Settings & Baseline Templates
    • AWR Baselines & Creating AWR Baselines
    • Managing Baselines with PL/SQL & Baseline Views
    • Performance Monitoring and Baselines & Defining Alert Thresholds Using a Static Baseline

    Identifying Problem SQL Statements

    • SQL Statement Processing Phases & Role of the Oracle Optimizer
    • Identifying Bad SQL, Real Time SQL Monitoring
    • What Is an Execution Plan? Methods for Viewing Execution Plans & Uses of Execution Plans
    • DBMS_XPLAN Package: Overview & EXPLAIN PLAN Command
    • Reading an Execution Plan, Using the V$SQL_PLAN View & Querying the AWR
    • SQL*Plus AUTOTRACE & SQL Trace Facility
    • How to Use the SQL Trace Facility
    • Generate an Optimizer Trace

    Influencing the Optimizer

    • Functions of the Query Optimizer, Selectivity, Cardinality and Cost & Changing Optimizer Behavior
    • Using Hints, Optimizer Statistics & Extended Statistics
    • Controlling the Behavior of the Optimizer with Parameters
    • Enabling Query Optimizer Features & Influencing the Optimizer Approach
    • Optimizing SQL Statements, Access Paths & Choosing an Access Path
    • Join & Sort Operations
    • How the Query Optimizer Chooses Execution Plans for Joins
    • Reducing the Cost

    Using SQL Performance Analyzer

    • Real Application Testing: Overview & Use Cases
    • SQL Performance Analyzer: Process & Capturing the SQL Workload
    • Creating a SQL Performance Analyzer Task & SPA DBMS_SQLTUNE.CREATE_TUNING_TASK
    • Comparison Report & Comparison Report SQL Detail

    SQL Performance Management

    • Maintaining SQL Performance and Optimizer Statistics & Automated Maintenance Tasks
    • Statistic Gathering Options & Setting Statistic Preferences
    • Restore Statistics
    • Deferred Statistics Publishing
    • Automatic SQL Tuning
    • SQL Tuning Advisor
    • Using the SQL Access Advisor
    • SQL Plan Management

    Using Database Replay

    • The Big Picture & System Architecture
    • Capture & Replay Considerations
    • Replay Options & Analysis
    • Packages and Procedures
    • Data Dictionary Views: Database Replay

    Tuning the Shared Pool

    • Shared Pool Architecture & Operation
    • The Library Cache & Latch and Mutex
    • Diagnostic Tools for Tuning the Shared Pool
    • Avoiding Hard & Soft Parses
    • Sizing the Shared Pool & Avoiding Fragmentation
    • Data Dictionary Cache & SQL Query Result Cache
    • Large Pool & Tuning the Large Pool

    Tuning the Buffer Cache

    • Oracle Database Architecture: Buffer Cache
    • Database Buffers
    • Buffer Cache Tuning Goals and Techniques
    • Buffer Cache Performance Symptoms & Solutions
    • Automatically Tuned Multiblock Reads
    • Flushing the Buffer Cache (for Testing Only)

    Tuning PGA and Temporary Space

    • SQL Memory Usage & Performance Impact
    • SQL Memory Manager
    • Configuring Automatic PGA Memory & Setting PGA_AGGREGATE_TARGET Initially
    • Monitoring & Tuning SQL Memory Usage
    • PGA Target Advice Statistics & Histograms
    • Automatic PGA and Enterprise Manager & Automatic PGA and AWR Reports
    • Temporary Tablespace Management: Overview & Monitoring Temporary Tablespace
    • Temporary Tablespace Shrink & Tablespace Option for Creating Temporary Table

    Automatic Memory Management

    • Oracle Database Architecture, Dynamic SGA & Memory Advisories
    • Increasing the Size of an SGA Component
    • Behavior of Auto-Tuned & Manually Tuned SGA Parameters
    • Using the V$PARAMETER View & Resizing SGA_TARGET
    • Disabling, Configuring & Monitoring Automatic Shared Memory Management (ASMM)

    Tuning Segment Space Usage

    • Space and Extent Management & Locally Managed Extents
    • How Table Data Is Stored & Anatomy of a Database Block
    • Minimize Block Visits
    • The DB_BLOCK_SIZE Parameter
    • Small & Large Block Size: Considerations
    • Block Allocation, Free Lists & Block Space Management with Free Lists
    • Automatic Segment Space Management
    • Migration and Chaining, Shrinking Segments & Table Compression

    Tuning I/O

    • I/O Architecture, File System Characteristics, I/O Modes & Direct I/O
    • Enterprise Manager
    • Stripe and Mirror Everything
    • Using RAID
    • I/O Diagnostics
    • Database I/O Tuning
    • What Is Automatic Storage Management?

    Certification creation

Performance Tuning trainer Profile & Placement

Our Performance Tuning Trainers

  • More than 10 Years of experience in Performance Tuning
  • Has worked on multiple realtime Performance Tuning projects
  • Working in a top MNC company in Chennai
  • Trained 2000+ Students so far
  • Strong Theoretical & PPerformance Tuningtical Knowledge
  • Performance Tuning certified Professionals

Performance Tuning Placement Training in Chennai

  • More than 2000+ students Trained
  • 93% percent Placement Record
  • 1100+ Interviews Organized

Performance Tuning training batch size in Chennai

Regular Batch ( Morning, Day time & Evening)

  • Seats Available : 8 (maximum)

Weekend Training Batch( Saturday, Sunday & Holidays)

  • Seats Available : 8 (maximum)

Fast TPerformance Tuningk batch

  • Seats Available : 5 (maximum)

Our Students are working in


About Our Training

Best IT Training provider for
more than 115+ software courses at adyar location and overall we successfully trained more than 10000+ students and most of them got perfect benefits from our training methodology.

Stay Connected

We are available at all social networks

Greens Technologys Greens Technologys Greens Technologys Greens Technologys


Best training institute awarded from
Yet5.com for the year of 2014.

Become registered vendor for
HP, Cognizant, AVNET, Prodapt, Renualt Nisson and more companies for their corporate training.

Successfully placed more than
100+ students in last month through our clients.

Useful Links

This may be the very useful and quick link for proper information

Training in chennai adyar
Average Rating: 5
Votes: 4.3
Reviews: 266
Training Courses
Corporate Training
Student Reviews
Contact Us

Contact us

Greens Technologys.
15, First Street, Padmanabha Nagar,
Landmark :Near adyar signal and Behind adyar anadha bhavan
P : 044 4351 1623
M : +(91) 89399 15577 / 89399 25577
E : contact[at]traininginadyar.in
W : www.traininginadyar.in

Copyright © 2015 Training Institute.  All Rights Reserved.The certification names are the trademarks of their respective owners.