Oracle Performance Tuning

Oracle Performance Tuning, available at $44.99, has an average rating of 4.05, with 19 lectures, based on 478 reviews, and has 2585 subscribers.

You will learn about 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. This course is ideal for individuals who are Oracle Database Developers or Oracle Database Administrators or Database Architect It is particularly useful for Oracle Database Developers or Oracle Database Administrators or Database Architect.

Enroll now: Oracle Performance Tuning

Summary

Title: Oracle Performance Tuning

Price: $44.99

Average Rating: 4.05

Number of Lectures: 19

Number of Published Lectures: 19

Number of Curriculum Items: 19

Number of Published Curriculum Objects: 19

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

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.

Who Should Attend

Oracle Database Developers
Oracle Database Administrators
Database Architect

Target Audiences

Oracle Database Developers
Oracle Database Administrators
Database Architect

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.

Course Curriculum

Chapter 1: Introduction

Lecture 1: Introduction and Course Layout

Chapter 2: Performance Tuning Overview

Lecture 1: Common Causes of Performance Tuning

Lecture 2: Different Approach

Lecture 3: Performance Tuning Methodology

Lecture 4: Baseline

Chapter 3: Sources of Tuning Information

Lecture 1: Alert Log

Lecture 2: Trace Files

Lecture 3: Automatic Workflow Repository

Lecture 4: Application Tracing and Performace Tuning views

Chapter 4: Understanding Database Statistics

Lecture 1: Database Statistics

Lecture 2: Oracle Optimizer

Lecture 3: Fragmentation and Maintenance Plan

Chapter 5: SQL Tuning

Lecture 1: TKPROF

Lecture 2: Explain Plan, Autotrace and General Guidelines of SQL Tuning

Chapter 6: Instance Tuning

Lecture 1: Instance Tuning

Chapter 7: Miscellaneous Tuning Techniques

Lecture 1: Plan Stability and Partition

Chapter 8: Demo

Lecture 1: Lock and waits demo

Lecture 2: Index Demo

Lecture 3: Autotrace Demo

Instructors

Amit Arora
Solution Architect

Rating Distribution

1 stars: 38 votes
2 stars: 47 votes
3 stars: 112 votes
4 stars: 141 votes
5 stars: 140 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu