Performance Tuning Training in Electronic City
Let eMexo Technologies Best Performance Tuning Training in Electronic City, Bangalore take you from the fundamentals of Performance Tuning to Advance Performance Tuning and make you an expert in Performance Tuning real time applications. Here are the major topics we cover under this Performance Tuning course Syllabus Introduction,Performance Tuning Overview,Basic Tuning Tools,Using Statspack,Using Automatic Workload Repository,Using AWR Based Tools,Defining Problems,Using Metrics and Alerts,Using Baselines,Identifying Problem SQL Statements,Influencing the Optimizer,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 Management,Tuning Segment Space Usage,Tuning I/O. Each topic will be covered in practical way with examples for our Performance Tuning Course in Electronic City.
All the topics will be covered with Practical and hands on training. Our trainers have industry experience with live project experience in cutting edge technologies which they teach. We hire only Best Performance Tuning industry specialists as trainer for our Performance Tuning training in Electronic City, Bangalore.
If you are looking for Performance Tuning Training in Electronic City eMexo Technologies is the Best Performance Tuning Training Institute in Electronic City. Come over to our training institute for a free demo class. Let our trainer give you a demo on Performance Tuning and only then you take the decision to enroll into the Performance Tuning Training in Electronic City.
Performance Tuning Training Institute in Electronic City Features
FAQs
Book Your Free Demo Class For Performance Tuning Course in Electronic City
-
Oracle Database 11g: Performance Tuning -Introduction
-
Performance Tuning Overview
-
Basic Tuning Tools
-
Using Statspack
-
Using Automatic Workload Repository
-
Using AWR Based Tools
-
Defining the Problem
-
Using Metrics and Alerts
-
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
-
SQL Performance Management
-
Using Database Replay
-
Tuning the Buffer Cache
-
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
-
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