Introduction to Performance Tuning
Introduction to Performance Tuning Features and Tools
Understanding Investment Options
Application Design Principles
Workload Testing, Modeling, and Implementation
Deploying New Applications
The Oracle Performance Improvement Method
Emergency Performance Methods
Performance Considerations for Initial Instance Configuration
Creating and Maintaining Tables for Good Performance
Performance Considerations for Shared Servers
Overview of Data Gathering
Automatic Workload Repository
Introduction to Database Diagnostic Monitoring
Automatic Database Diagnostic Monitor
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
Basic I/O Configuration
Understanding Operating System Performance Issues
Solving Operating System Problems
Finding System CPU Utilization
Instance Tuning Steps
Interpreting Oracle Statistics
Wait Events Statistics
Idle Wait Events
Understanding Connection Models
Detecting Network Problems
Solving Network Problems
Introduction to SQL Tuning
Goals for Tuning
Identifying High-Load SQL
Automatic SQL Tuning Features
Developing Efficient SQL Statements
Automatic SQL Tuning Overview
SQL Tuning Advisor
Managing SQL Profiles with APIs
SQL Tuning Sets
SQL Tuning Information Views
Choosing an Optimizer Goal
Enabling and Controlling Query Optimizer Features
Understanding the Query Optimizer
Understanding Access Paths for the Query Optimizer
Automatic Statistics Gathering
Manual Statistics Gathering
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
Understanding Optimizer Hints
Using Optimizer Hints
Using Plan Stability to Preserve Execution Plans
Using Plan Stability with Query Optimizer Upgrades
Understanding EXPLAIN PLAN
The PLAN_TABLE Output Table
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
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
06 Mar, 2021 - 10 Apr, 2021
07 Mar, 2021 - 06 Apr, 2021
10 Mar, 2021 - 25 Mar, 2021
13 Mar, 2021 - 17 Apr, 2021
14 Mar, 2021 - 13 Apr, 2021
17 Mar, 2021 - 01 Apr, 2021
Mindmajix specializes in delivering dedicated, customized and role-based Performance Tuning training course to individuals and companies according to their convenience.
Upon completion of Performance Tuning Training, the trainee will be able to:
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:
There are no prerequisites required to learn Oracle Performance Tuning. Knowing the below core activities is beneficial:
The Performance Tuning Certification training from Mindmajix helps you gain expertise in the following areas:
Our Oracle Performance Tuning course covers all the topics that are required to clear Oracle Performance Tuning certification. Trainer will share Oracle Performance Tuning certification guide, Oracle Performance Tuning certification sample questions, Oracle Performance Tuning certification practice questions.
Trusted By Companies Worldwide & 4,10,350+ Learners
Yes, you get two kinds of discounts. They are group discount and referral discount. Group discount is offered when you join as a group, and referral discount is offered when you are referred from someone who has already enrolled in our training.
The trainer is a certified consultant and has significant amount of experience in working with the technology.
Yes, we accept payments in two installments.
If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within first 2 sessions of the training. Please make a note that refunds will be processed within 30 days of prior request.
User Reviews on popular courses
Thank You for the sessions that helped me gaining knowledge in Oracle Performance Tuning. Trainers experience helped me to get detailed information regarding the key concepts and challenging tasks in real time. Thanks again.
The trainer of the mindmajix is top-rated and highly professional. This online course helped me to get a vast knowledge of Oracle Performance Tuning. Excellent and Greate learning experience with Mindmajix.
It was a great experience to undergo and get certified in Oracle Perfomance Tuning course from Mindmajix. The trainer had a great hold on the domain, who came with a handy industry experience. Quality of the training materials, assignments, project, support and other infrastructures are a top notch. Thanks Mindmajix and team! Pleasure being an associate.
I took .NET training from Mindmajix. I must say the course content was highly qualitative and the trainer covered all concepts. Overall it was a good experience with Mindmajix.
Thank You for the sessions that helped me gaining knowledge in Spotfire training. Trainer's experience helped me to get the detailed information regarding the key concepts and challenging tasks in real-time. Thanks once again.
Perfect sessions to know all the key concepts of Spotfire certification training. Thanks to the support team as well. Thanks to Mindmajix.
Servicenow training offered by MindMajix is excellent, and you clear Servicenow certification very easily after attending this training, and also you will get the real time view of the Servicenow.