Oracle Performance Tuning
3.0 (51 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.
636 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle Performance Tuning to your Wishlist.

Add to Wishlist

Oracle Performance Tuning

This tutorial will provide a good foundation of Oracle performance tuning along with handy tips for issue resolution.
3.0 (51 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.
636 students enrolled
Created by Amit Arora
Last updated 1/2017
English
Current price: $10 Original price: $50 Discount: 80% off
1 day left at this price!
30-Day Money-Back Guarantee
Includes:
  • 3 hours on-demand video
  • 3 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I 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.
View Curriculum
Requirements
  • Basic understanding of Oracle database.
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.

Who is the target audience?
  • Oracle Database Developers
  • Oracle Database Administrators
  • Database Architect
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 19 Lectures Collapse All 19 Lectures 03:13:17
+
Introduction
1 Lecture 04:54
+
Performance Tuning Overview
4 Lectures 29:18

Different Approach
07:38

Performance Tuning Methodology
08:50

Baseline
03:18
+
Sources of Tuning Information
4 Lectures 42:23
Alert Log
07:42

Trace Files
06:02

Automatic Workflow Repository
16:40

Application Tracing and Performace Tuning views
11:59
+
Understanding Database Statistics
3 Lectures 30:44
Database Statistics
08:11

Oracle Optimizer
11:28

Fragmentation and Maintenance Plan
11:05
+
SQL Tuning
2 Lectures 32:09
TKPROF
15:57

Explain Plan, Autotrace and General Guidelines of SQL Tuning
16:12
+
Instance Tuning
1 Lecture 21:07
Instance Tuning
21:07
+
Miscellaneous Tuning Techniques
1 Lecture 18:02
Plan Stability and Partition
18:02
+
Demo
3 Lectures 14:40
Lock and waits demo
04:56

Index Demo
04:57

Autotrace Demo
04:47
About the Instructor
Amit Arora
3.3 Average rating
70 Reviews
777 Students
3 Courses
Data Integration Specialist

I have over 16 years of experience with databases (primarily with Oracle and SQL Server and NoSQL 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.

I completed MongoDB courses with full score from MongoDB university and practically implimented the solution for various applications.