Oracle Performance Tuning Training

(3) 3 Ratings

Course Schedule

30

JUL

Mon - Sat

07:30 PM - 10:00 PM ( IST )

06

AUG

Mon - Fri

11:00 AM - 02:00 PM ( IST )

11

AUG

Sat - Sun

05:30 AM - 06:30 AM ( IST )


Total Learners

567 Learners


LMS Access

365 days

Course duration

30 days


Support

24/7 support

Can't find convenient schedule?

Our experts can help you find a batch that meets your needs

The Instructor for this course is from one of the Big5 Companies in the world.

Drop us a Query

I agree to the Training T&C

Modes of Training

Corporate Training

Live, Classroom Or Self Paced Training

Online Classroom

Attend our Instructor Led Online Virtual Classroom

Self Paced Training

Comprehensive Recorded Videos by Experts to learn at your own pace

Course Features

Live Instructor-led Classes

This isn't canned learning. Its dynamic, its interactive, its effective

Expert Educators

Only the best or they're out. We are constantly evaluating our trainers

24&7 Support

We never sleep. Need something answered at 3 am? No Problem

Flexible Schedule

You don't learn as per our calendar. We work according to yours

☰ Details

Course Curriculum

Performance Tuning Overview

  • Introduction to Performance Tuning
  • Introduction to Performance Tuning Features and Tools.

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

Performance Improvement Methods

  • The Oracle Performance Improvement Method
  • Emergency Performance Methods. 

Configuring A Database For Performance

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

Configuring a Database for Performance

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

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.

Understanding Operating System Resources

  • Understanding Operating System Performance Issues
  • Solving Operating System Problems.

Tuning Networks

  • Understanding Connection Models
  • Detecting Network Problems
  • Solving Network Problems 

SQL Tuning Overview

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

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 

Course Description

What are the Course Objectives for this Training?

  • Apply sound database design principles to ensure high performance
  • Identify appropriate metrics and tuning goals for measuring and monitoring performance
  • Identify the critical performance tuning steps
  • Interpret Oracle alert files
  • Use Oracle trace files
  • Use Oracle utilities for performance tuning
  • Use the V$ utilities for tuning
  • Employ tuning techniques for different types of applications

Who Should Attend This Training?

  • Database Administrators
  • Support Engineer
  • Technical Consultant
  • End Users
  • Professionals who are looking to extend their knowledge towards advanced technologies.

What are the Pre-requisites for this Training Course

  • A general understanding of database administration
  • Skills and knowledge commensurate with Oracle's Database 11g: Administration Workshop I and Workshop II, or equivalent experience
  • Oracle Database 11g: Administration Workshop I - Self-Study Course
  • Oracle Database 11g: Administration Workshop II - Self-Study Course.

FAQ

Do you have self paced training?

Yes, we offer self paced training

How do you provide training?

We offer three different modes of training. Instructor Led Live Training, Self Paced Training and Corporate Training

Do you offer any discounts?

Yes we offer discounts for group of 3 plus people.

Can I choose timings that suits my schedule?

Yes we are the only company where we work with students and offer flexible timings which fits your schedule

Who are the Instructors?

All our instructors are from MNC companies who have real time experience of more than 10 years.

Can I attend a demo session before joining?

Yes we offer a free demo session with the instructors. The trainer will answer all your queries and share the course agenda.

Course Reviews

Murthy

Had a Great Experience in learning the Course with LTB. The trainer has a Practical Knowledge about the subject and taught us with real-time scenarios. Thank you LTB.

Sruthi

I joined for Oracle performance tuning course that training more helpful to me. The trainer explained a lot of sessions and had complete knowledge about this oracle performance tuning. Very thanks LTB.

Avinash

It is a great experience to learn online courses through Live Training Bangalore. The sessions are very professional. I had enrolled for performance tuning course. It helped me a lot professionally at my workplace. I am very glad for choosing LTB as my learning partner. Thank you.