Oracle Performance Tuning

This tutorial will provide a good foundation of Oracle performance tuning along with handy tips for issue resolution.
4.0 (29 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
523 students enrolled
Instructed by Amit Arora Development / Databases
$50
Take This Course
  • Lectures 16
  • Contents Video: 3 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 3/2014 English

Course Description

You will get a conceptual understanding of various Oracle database performance issues and learn about different places to check for the performance information along with tuning approach.

Broadly this course will cover following:

1. What are common oracle database performance issues?

2. Where to check for messages / tuning information to get to bottom of issue.

3. Different tuning approaches - based on different databases (OLTP vs Data Warehouse).

4. Learn about database statistics, optimizer and maintenance plan for tables and indexes.

5. SQL and Instance tuning details.

6. General guidelines for avoiding performance issues in Oracle database.

What are the requirements?

  • Basic understanding of Oracle database.

What am I going to get from this course?

  • By the end of this course, you will have good idea about various performance issues with Oracle database. This course provide comprehensive material for the performance tuning including:
  • • Common Causes of performance issues.
  • • Places to check for performance issues.
  • • Approach to resolve performance issues.
  • • Performance tuning resolution tips.
  • • SQL tuning, Instance tuning and miscellaneous tuning techniques.

What is the target audience?

  • Oracle Database Developers
  • Oracle Database Administrators
  • Database Architect

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Introduction
Introduction and Course Layout
Preview
04:54
Section 2: Performance Tuning Overview
Common Causes of Performance Tuning
Preview
09:32
Different Approach
07:38
Performance Tuning Methodology
08:50
Baseline
03:18
Section 3: Sources of Tuning Information
Alert Log
07:42
Trace Files
06:02
Automatic Workflow Repository
16:40
Application Tracing and Performace Tuning views
11:59
Section 4: Understanding Database Statistics
Database Statistics
08:11
Oracle Optimizer
11:28
Fragmentation and Maintenance Plan
11:05
Section 5: SQL Tuning
TKPROF
15:57
Explain Plan, Autotrace and General Guidelines of SQL Tuning
16:12
Section 6: Instance Tuning
Instance Tuning
21:07
Section 7: Miscellaneous Tuning Techniques
Plan Stability and Partition
18:02

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Amit Arora, Data Integration Specialist

I have over 16 years of experience with databases (primarily with Oracle and SQL Server databases). In this period, I worked in every phase of Software development life cycle including database developer and database administrator, data modelling, etc.

I am an Oracle certified DBA and handing Oracle / SQL Server projects in my jobs. I am regular blogger for various sites and written Oracle/ SQL related articles along with certification tests for Oracle, PMP and more.

Ready to start learning?
Take This Course