Oracle Performance Tuning

Home / Services / Training / Live Virtual Class / Oracle Performance Tuning

Course Overview

Oracle Performance Tuning training will develop the skills and knowledge required to improve the performance of the SQL query. You will learn how to design and develop a well tuned query.

Modes of Training

Instructor-led Training (Online)

Curriculum

Sr No.	Topics
1	Basic Concepts of Oracle Performance Engineering/Tuning
2	What is Cost Based Optimizer (CBO) and related concepts ?
3	What is Statistics , Cardinality , Selectivity ?
4	Full Table Scan , Index scan (Range scan, skip scan, unique scan)
5	Index type (B*tree, Bitmap, Function)
6	Access Path , Join Orders , Join Methods
7	How to interpret TKPROF, Time statistics, Row Source Operations, Explain Plan for given Oracle Programs with real time scenario.
8	How to change the behavior of Optimizer for specific SQL with optimal Plan
9	Techniques of using appropriate Hints to resolve various performance issues by plan stability thru CBO
10	Various real performance case studies/examples in details
11	How to read trace files to find the exact Performance RCA analysis with resolution
12	Histogram (Frequency & Height Balance) & their usage
13	How to Tune complex SQL queries ?
14	Rewrite queries into more efficient form, GTT, MV, EXISTS , redesign, Partition
15	Bulk Collect with LIMIT & FOR ALL to avoid Context switches
16	Set Based DML operations
17	Index design strategies based on business needs, table structures, data distributions.
18	FTS Vs Index scan, Optimal Index usage/join technique
19	how to avoid Full Table Scan (FTS) ?
20	Scalar subquery, co-related & non co-related subquery
21	Effective usage of Input mapping to Where clause predicates
22	Implicit and explicit conversion
23	Bind Peeking, Invisible indexes , SQL Plan management
24	With Clause + Materialize hint structure
25	Best new features of 10g/11g and Top Performance tuning techniques to improve response time in no time.
26	How to avoid DBLink wait events to avoid multiple network trips for distribute SQL queries.
27	Soft parsing vs Hard parsing
28	Data caching techniques
29	How to measure performance (response time, throughput, workload, resource utilization, scalability)

Course Objectives

What are the Objectives of Oracle Performance Tuning Online Training ?

CyberMeru specializes in delivering SQL query Performance Tuning training course to individuals and companies according to their convenience.
Upon completion of Performance Tuning Training, the trainee will be able to:
Diagnosing SQL related performance problems and tuning them
Operate and manage Query optimizer features.
Interpret Execution Plans
Describe Oracle optimizer fundamentals

Why should you learn Performance Tuning to grow your career?

Many IT giants are adopting Oracle Performance Tuning and opportunities are not limited. It is one of the trending databases in industries now.
The market demand for certified Oracle Performance Tuning professionals is skyrocketing.

Who should learn Performance Tuning?

This Performance Tuning Certification training is ideal for individuals who are interested in database technologies. The training is the best fit for the following job roles:

Technical Consultant
Support Engineer

What are the prerequisites for the Performance Tuning course?

Course Duration

10 hours (daily 2 hours for 5 days)

Course Fees

INR 10000 (excluding GST)