Course content

About Oracle Performance Tuning

Do You Have a Running Database in Your PC?

Why to know the Oracle Database Architecture and how much to know?

Oracle Database Architecture Overview (Part 1)

Oracle Database Architecture Overview (Part 2)

Database Data Blocks in Detail

What is PGA?

What is Shared Pool?

What is Buffer Cache?

What is Redo Log Buffer?

What is Undo?

How a DML is processed and committed

Automatic Memory Management

Oracle Database Storage Architecture

Logical and Physical Database Structure

When to Tune?

What is a Bad SQL?

Effective Schema Design

Table Partitioning

How an SQL Statement is Processed?

Why do we need the Optimizer?

Optimizer Overview

Query Transformer

Selectivity & Cardinality

What is "cost" in detail?

Plan Generator

Row Source Generator

SQL Tuning Principles and Strategies

Query Analysis Strategy

SQL Tuning Basics Assessment Test

Execution Plan and Explain Plan in Details

Generating Statistics (Part 1)

Generating Statistics (Part 2)

Generating Statistics (Part 3)

Generating Statistics (Code Samples)

Generating Execution Plan

Generating Execution Plan (Code Samples)

Autotrace

Autotrace (Code Samples)

V$SQL_PLAN View

V$SQL_PLAN (Code Samples)

Reading the Execution Plans (Part 1)

Reading the Execution Plans (Part 2)

Reading the Execution Plans (Code Samples)

Analyzing the Execution Plans

What are Indexes and How They work in details?

Types of Table and Index Access Paths

Table Access Full

Table Access Full (Code Samples)

Table Access by ROWID

Table Access by ROWID (Code Samples)

Index Unique Scan

Index Range Scan

Index Range Scan (Code Samples)

Index Full Scan

Index Full Scan (Code Samples)

Index Fast Full Scan

Index Fast Full Scan (Code Samples)

Index Skip Scan

Index Skip Scan (Code Samples)

Index Join Scan

Index Join Scan (Code Samples)

Table & Index Access Paths

What are Hints and Why to Use Them?

How to use Hints

How to use Hints (Code Samples)

List of Some Useful Hints

Join Methods Overview

Nested Loop Joins

Nested Loop Join (Code Samples)

Sort Merge Joins

Sort Merge Join (Code Samples)

Hash Joins

CODE: Hash Joins

Cartesian Joins

CODE: Cartesian Joins

Join Types Overview

Equijoins & Nonequijoins

CODE: Equijoins & Nonequijoins

Outer Joins

CODE: Outer Joins

Semijoins

CODE: Semijoins

Antijoins

CODE: Antijoins

Join Operations

Result Cache Operator

CODE: Result Cache Operator

View Operator

CODE: View Operator

Clusters

CODE: Clusters

Sort Operators

CODE: Sort Operators

INLIST Operator

CODE: INLIST Operator

Count Stopkey Operator

CODE: Count Stopkey Operator

First Row Operator

CODE: First Row Operator

Filter Operator

CODE: Filter Operator

Concatenation Operator

CODE: Concatenation Operator

UNION Operators

CODE: Union Operators

Intersect Operator

CODE: Intersect Operator

Minus Operator

CODE: Minus Operator

How to find a performance problem and its tuning solution?

Ways of Getting the Execution Plan and the Statistics

Using the Real-Time SQL Monitoring Tool Part 1

Using the Real-Time SQL Monitoring Tool Part 2

Using the Real-Time SQL Monitoring Tool Part 3

CODE: Using the Real-Time SQL Monitoring Tool

Using the Trace Files & TKPROF Utility - Part 1

Using the Trace Files & TKPROF Utility - Part 2

Using the Trace Files & TKPROF Utility - Part 3

CODE: Using the Trace Files & TKPROF Utility

Get What You Need Only

CODE: Get What You Need Only

Index Usage

CODE: Index Usage

Using Concatenation Operator

CODE: Using Concatenation Operator

Using Arithmetic Operators

CODE: Using Arithmetic Operators

Using Like Conditions

CODE: Using Like Conditions

Using Functions on the Indexed Columns

CODE: Using Functions on the Indexed Columns

Handling NULL-Based Performance Problems

CODE: Handling NULL-Based Performance Problems

Using EXISTS instead of IN Clause

Using TRUNCATE instead of DELETE command

CODE: Using TRUNCATE instead of DELETE command

Data Type Mismatch

CODE: Data Type Mismatch

Tuning Ordered Queries

CODE: Tuning Ordered Queries

Retrieving the MIN & MAX Values

CODE: Retrieving the MIN & MAX Values

UNION and UNION ALL Operators (Which one is faster?)

Avoid Using the HAVING Clause!

CODE: Avoid Using the HAVING Clause!

Be Careful on Views!

CODE: Be Careful on Views!

Create Materialized Views

CODE: Create Materialized Views

Avoid Commit Too Much or Too Less!

Partition Pruning

CODE: Partition Pruning

Using BULK COLLECT

CODE: Using BULK COLLECT

Tuning the Join Order

CODE: Tuning the Join Order

Multitable DML Operations

CODE: Multitable DML Operations

Using Temporary Tables

CODE: Using Temporary Tables

Combining SQL Statements

CODE: Combining SQL Statements

Using "WITH" Clause

CODE: Using WITH Clause

Using Analytical Functions

CODE: Using Analytical Functions

Execution Plan and Explain Plan in Details

Generating Statistics (Part 1)

Generating Statistics (Part 2)

Generating Statistics (Part 3)

Generating Statistics (Code Samples)

Generating Execution Plan

Generating Execution Plan (Code Samples)

Autotrace

Autotrace (Code Samples)

V$SQL_PLAN View

V$SQL_PLAN (Code Samples)

Reading the Execution Plans (Part 1)

Reading the Execution Plans (Part 2)

Reading the Execution Plans (Code Samples)

Analyzing the Execution Plans

Analyzing the Execution Plans (Code Samples)

What are Indexes and How They work in details?

Types of Table and Index Access Paths

Table Access Full

Table Access Full (Code Samples)

Table Access by ROWID

Table Access by ROWID (Code Samples)

Index Unique Scan

Index Range Scan

Index Range Scan (Code Samples)

Index Full Scan

Index Full Scan (Code Samples)

Index Fast Full Scan

Index Fast Full Scan (Code Samples)

Index Skip Scan

Index Skip Scan (Code Samples)

Index Join Scan

Index Join Scan (Code Samples)

Table & Index Access Paths

What are Hints and Why to Use Them?

How to use Hints

How to use Hints (Code Samples)

List of Some Useful Hints

Join Methods Overview

Nested Loop Joins

Nested Loop Join (Code Samples)

Sort Merge Joins

Sort Merge Join (Code Samples)

Hash Joins

CODE: Hash Joins

Cartesian Joins

CODE: Cartesian Joins

Join Types Overview

Equijoins & Nonequijoins

CODE: Equijoins & Nonequijoins

Outer Joins

CODE: Outer Joins

Semijoins

CODE: Semijoins

Antijoins

CODE: Antijoins

Join Operations

Result Cache Operator

CODE: Result Cache Operator

View Operator

CODE: View Operator

Clusters

CODE: Clusters

Sort Operators

CODE: Sort Operators

INLIST Operator

CODE: INLIST Operator

Count Stopkey Operator

CODE: Count Stopkey Operator

First Row Operator

CODE: First Row Operator

Filter Operator

CODE: Filter Operator

Concatenation Operator

CODE: Concatenation Operator

UNION Operators

CODE: Union Operators

Intersect Operator

CODE: Intersect Operator

Minus Operator

CODE: Minus Operator

Index Selectivity & Cardinality

B-Tree Indexes in Details

CODE: B-Tree Indexes in Details

Bitmap Indexes in Details

CODE: Bitmap Indexes in Details

Bitmap Operations

Composite Indexes and Order of Indexed Columns

CODE: Composite Indexes and Order of Indexed Columns

Covering Indexes

CODE: Covering Indexes

Reverse Key Indexes

Bitmap Join Indexes

CODE: Bitmap Join Indexes

Combining Bitmap Indexes

CODE: Combining Bitmap Indexes

Function-Based Indexes

CODE: Function-Based Indexes

Index-Organized Tables

CODE: Index-Organized Tables

Cluster Indexes

CODE: Cluster Indexes

Invisible Indexes

CODE: Invisible Indexes

Index Key Compression- Part 1

Index Key Compression- Part 2

CODE: Index Key Compression

Full-Text Searches

Tuning Star Queries

CODE: Tuning Star Queries

Using Bind Variables

CODE: Using Bind Variables

Beware of Bind Variable Peeking

CODE: Beware of Bind Variable Peeking

Cursor Sharing

CODE: Cursor Sharing

Adaptive Cursor Sharing

CODE: Adaptive Cursor Sharing

Adaptive Plans

Why Should You Learn Oracle Performance Tuning Training?

The annual salary of an Oracle Performance Tuning is $125k.

Request more information

TRAINING FEATURES

Instructor-led Sessions

Engage in live, interactive sessions led by industry experts, ensuring better guidance, monitoring, and flexible learning from any internet-enabled device.

Real-life Case Studies

Gain practical insights through case studies based on real-world industry applications, helping bridge the gap between theory and practice.

Assignments

Enhance your analytical skills and understanding with hands-on assignments designed to reinforce key concepts and practical application.

Lifetime Access

Enjoy unrestricted access to course materials for a lifetime, allowing you to learn and revisit topics at your own pace.

24/7 Expert Support

Get round-the-clock assistance from experienced mentors to resolve your queries and enhance your learning experience.

Certification

Earn industry-recognized certification upon course completion, validating your skills and boosting your career prospects.

Track

Week Days

Course Duration

Fast Track

Week Days

40-45 Days

2 Hrs. Per Day

Online

Course Duration

7 Weekends

3 Hrs. Per Day

Online

Fast Track

8 Days

6+ Hrs. Per Day

Online

Students Reviews

Explore authentic student feedback on ZebLearn’s expert-led SAP training and foreign language courses. Discover success stories from learners who earned certifications, enhanced their skills, and advanced their careers!

Ananya Gupta

Database Administrator

Studying Oracle Performance Tuning at ZeblearnIndia was incredibly beneficial. The course provided practical techniques to optimize database performance, and the instructors were highly knowledgeable. I now have the skills to effectively manage and tune Oracle databases.

Rajesh Kumar

IT Consultant

The Oracle Performance Tuning course at ZeblearnIndia was comprehensive and well-paced. The instructors provided clear explanations and useful tips for optimizing Oracle databases. Its been a rewarding learning experience.

Priya Patel

Database Developer

Enrolling in ZeblearnIndias Oracle Performance Tuning course was a game-changer for my career. The course covered everything from SQL optimization to memory management techniques. The practical exercises were invaluable in honing my skills.

Meera Sharma

Software Engineer

I'm impressed with ZeblearnIndias Oracle Performance Tuning course. The course materials were up-to-date, and the practical sessions helped me understand the nuances of performance tuning in Oracle databases. Definitely worth the investment!

Arjun Singh

Systems Analyst

ZeblearnIndias Oracle Performance Tuning course exceeded my expectations. The course content was detailed, and the hands-on labs allowed me to apply performance tuning strategies in real-world scenarios. Highly recommended for anyone managing Oracle databases!

Date

Type

Schedule

Time

SOLD OUT

19 May 2025

Weekend

SAT - SUN (08 Week)

18:00 To 20:00

24 May 2025

Weekday

MON - FRI (08 Week)

08:00 To 10:00

29 May 2025

Weekend

MON - FRI (08 Week)

10:00 To 00:00

Oracle Performance Tuning Training Program

Check Your Course Fee

KEY POINTS

90+

18+

1500+

5+

ZebLearn Certification Partners – Globally Recognized Credentials!

Course content

Why Should You Learn Oracle Performance Tuning Training?

Request more information

What you will get at Zeblearnindia Learning?

TRAINING FEATURES

Instructor-led Sessions

Real-life Case Studies

Assignments

Lifetime Access

24/7 Expert Support

Certification

We're Here to Help!

Phone Support

WhatsApp Support

(19 May ) 60 Minutes WEBINAR with CERTIFICATE

Students Reviews

Ananya Gupta

Rajesh Kumar

Priya Patel

Meera Sharma

Arjun Singh