Oracle Performance Tuning Training and Certification Course Online

Mindmajix Technologies

Online

₹ 8900 11125

Quick Facts

particular	details
Medium of instructions English	Mode of learning Self study, Virtual Classroom	Mode of Delivery Video and Text Based	Frequency of Classes Weekdays, Weekends

Course and certificate fees

Fees information

₹ 8,900 ₹11,125

certificate availability

Yes

certificate providing authority

Mindmajix Technologies

The syllabus

Module 1 - Performance Tuning Overview

Introduction to Performance Tuning
Introduction to Performance Tuning Features and Tools

Module 2 - Designing And Developing For Performance

Oracle Methodology
Understanding Investment Options
Understanding Scalability
System Architecture
Application Design Principles
Workload Testing, Modeling, and Implementation
Deploying New Applications

Module 3 - Performance Improvement Methods

The Oracle Performance Improvement Method
Emergency Performance Methods

Module 4 - Configuring A Database For Performance

Performance Considerations for Initial Instance Configuration
Creating and Maintaining Tables for Good Performance
Performance Considerations for Shared Servers

Module 5 - Automatic Performance Statistics

Overview of Data Gathering
Automatic Workload Repository

Module 6 - Automatic Performance Diagnostics

Introduction to Database Diagnostic Monitoring
Automatic Database Diagnostic Monitor

Module 7 - Memory Configuration And Use

Understanding Memory Allocation Issues
Configuring and Using the Buffer Cache
Configuring and Using the Shared Pool and Large Pool
Configuring and Using the Redo Log Buffer
PGA Memory Management

Module 8 - I/O Configuration And Design

Understanding I/O
Basic I/O Configuration

Module 9 - Understanding Operating System Resources

Understanding Operating System Performance Issues
Solving Operating System Problems

Module 10 - Understanding CPU

Finding System CPU Utilization

Module 11 - Instance Tuning Using Performance Views

Instance Tuning Steps
Interpreting Oracle Statistics
Wait Events Statistics
Idle Wait Events

Module12 - Tuning Networks

Understanding Connection Models
Detecting Network Problems
Solving Network Problems

Module 13 - SQL Tuning Overview

Introduction to SQL Tuning
Goals for Tuning
Identifying High-Load SQL
Automatic SQL Tuning Features
Developing Efficient SQL Statements

Module 14 - Automatic SQL Tuning

Automatic SQL Tuning Overview
SQL Tuning Advisor
Managing SQL Profiles with APIs
SQL Tuning Sets
SQL Tuning Information Views

Module 15 - The Query Optimizer

Optimizer Operations
Choosing an Optimizer Goal
Enabling and Controlling Query Optimizer Features
Understanding the Query Optimizer
Understanding Access Paths for the Query Optimizer
Understanding Joins

Module 16 - Managing Optimizer Statistics

Understanding Statistics
Automatic Statistics Gathering
Manual Statistics Gathering
System Statistics
Managing Statistics
Viewing Statistics

Module 17 - Using Indexes And Clusters

Understanding Index Performance
Using Function-based Indexes for Performance
Using Partitioned Indexes for Performance
Using Index-Organized Tables for Performance
Using Bitmap Indexes for Performance
Using Bitmap Join Indexes for Performance
Using Domain Indexes for Performance
Using Clusters for Performance
Using Hash Clusters for Performance

Module 18 - Optimizer Hints

Understanding Optimizer Hints
Using Optimizer Hints

Module 19 - Using Plan Stability

Using Plan Stability to Preserve Execution Plans
Using Plan Stability with Query Optimizer Upgrades

Module 20 - Using EXPLAIN PLAN

Understanding EXPLAIN PLAN
The PLAN_TABLE Output Table

Module 21 - Running EXPLAIN PLAN

Displaying PLAN_TABLE Output
Reading EXPLAIN PLAN Output
Viewing Parallel Execution with EXPLAIN PLAN
Viewing Bitmap Indexes with EXPLAIN PLAN
Viewing Partitioned Objects with EXPLAIN PLAN

Module 22 - Using Application Tracing Tools

End to End Application Tracing
Using the trcsess Utility
Understanding SQL Trace and TKPROF
Using the SQL Trace Facility and TKPROF
Avoiding Pitfalls in TKPROF Interpretation
Sample TKPROF Output

Module 23 - Practice Test & Interview Questions

Articles

Trending Courses

Popular Courses

General Management Courses Public Health Courses Teaching and Education Courses Financial Management Courses Web Development Courses Mathematics Courses Programming Courses Data Science Courses Cyber Security Courses Digital Marketing Courses Law Courses Mechanical Engineering Courses Explore all courses

Popular Platforms

upGrad Courses Udemy Courses Swayam Courses Edx Courses Coursera Courses NPTEL Courses Futurelearn Courses Mindmajix Technologies Courses Vskills Courses IIT Kharagpur Courses IIT Kanpur Courses Emeritus Courses Explore all platforms

Learn more about the Courses

10 Reasons to Enrol Yourself in a Digital Marketing Course 8 Must-Have Skills for AWS Cloud Architects Planning to Upskill Yourself? Enrol for a Program in Data Science 25+ Tips for Improving Your Graphic Design Skills Top Universities in India Offering Cyber Security Courses 15+ Courses for Learning Data Mining How to Make a Career in the Field of Artificial Intelligence Top 10 Benefits Of Holding A Certification In Business Intelligence Which are the best certification courses for Photography in India A Beginner's Guide to Pursue Python Programming Want to Pursue a Career in Blockchain Technology? Here is all that you need to Know How Entrepreneurs Can Use Machine Learning to Make their Business Successful? The Scope of Artificial Intelligence in India Top 10 Online Courses for Travel Lovers 10 Best Certification Courses After Hospital and Healthcare Management

Open in App

Get the Careers360 App today!

And never miss an important update

Download Careers360 App

All this at the convenience of your phone

Regular Exam Updates
Best College Recommendations
College & Rank predictors
Detailed Books and Sample Papers
Question and Answers

Popular Searches