MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

Oracle Performance Tuning for Developers

Course Summary

Oracle is one of the most popular database systems in use today. Yet many developers do not understand how Oracle works or the principles behind developing high performance Oracle applications. This course targets the .NET or Java developer who is writing

  • +

    Course Syllabus

    ● Why Performance Tuning Matters
        ◦ Introduction
        ◦ Performance Tuning is Not Magic
        ◦ Performance Tuning Approach
        ◦ Performance Tuning Principles
        ◦ Sample Database
    ● Oracle Architecture and Performance Basics
        ◦ Introduction
        ◦ System Scalability
        ◦ Oracle Architecture Overview
        ◦ Buffer Cache
        ◦ Shared Pool
        ◦ Program Global Area
        ◦ Oracle Architecture Wrap Up
        ◦ Performance Metrics
        ◦ Performance Tuning and Database Size
        ◦ Building Effective Performance Test Databases
        ◦ Performance Tuning Database use Scenarios
    ● Connections and Connection Pools
        ◦ Introduction
        ◦ Using a Connection Pool in .NET
        ◦ Using a Connection Pool in Java
        ◦ Connection Pool Best Practices
        ◦ Summary
    ● Bind Variables
        ◦ Introduction
        ◦ The Shared SQL Area
        ◦ Contention and Latch Waits
        ◦ Matching SQL Statements
        ◦ Using Bind Variables in Applications
        ◦ Sample Application to Compare Approaches
        ◦ Evaluation Impacts of Bind Variables
    ● Statement Level Performance Tuning
        ◦ What is an Execution Plan
        ◦ Getting an Execution Plan
        ◦ What Does an Execution Plan Contain?
        ◦ Reading an Execution Plan
        ◦ Analyzing an Execution Plan
        ◦ Autotrace Introduction
        ◦ Autotrace Example in SQL Developer
        ◦ Autotrace Example in SQL*Plus
        ◦ Data Size and Execution Plans
        ◦ Summary
    ● Execution Plans in Depth
        ◦ Introduction
        ◦ Table Access Operations
        ◦ Index Lookup Operations
        ◦ Index Full Scan Operations
        ◦ Join Operations
        ◦ Tuning SQL Statements
    ● Indexing Essentials
        ◦ Why Indexing Matters
        ◦ B-Tree Indexes
        ◦ Bitmap Indexes
        ◦ Index Column Order Matters
        ◦ Index Skip Scan Operations
        ◦ Index Selectivity
        ◦ Selectivity for Composite Indexes
        ◦ Determining Index Column Order
    ● Advanced Indexing Techniques
        ◦ Module Outline
        ◦ Covering Indexes
        ◦ Function Based Indexes Introduction
        ◦ Selective Row Indexing With Function Based Indexes
        ◦ Index Compression
        ◦ Invisible Indexes
        ◦ Summary
    ● Application Indexing Practices
        ◦ Introduction
        ◦ What Should I Index?
        ◦ Indexing Costs and Overhead
        ◦ Similar Indexes
        ◦ Monitoring Index Usage
        ◦ Why isn't Oracle Using My Index?
        ◦ Missing Leading Edge of Index
        ◦ Index not Selective Enough
        ◦ Using a Like Clause and a Leading Wildcard
        ◦ Like Clauses and Index Selectivity
        ◦ Function in the Where Clause
        ◦ Data Type Conversion in the Where Clause
        ◦ Outdated Database Statistics
        ◦ Summary
    ● Monitoring Oracle Applications
        ◦ Motivation for Performance Monitoring
        ◦ Required Permissions
        ◦ Introduction to Queries
        ◦ Session Information
        ◦ Session Resource Usage
        ◦ What Statements are Running Right Now?
        ◦ Finding the Worst Performing Statements
        ◦ Statements Conducting Full Scan Operations
        ◦ Retrieving Execution Plans
        ◦ Monitoring Index Usage
        ◦ Monitoring Hard Parsing and SQL Using Literal Values
        ◦ Table Information
        ◦ Index Information
        ◦ Summary
    ● Pitfalls and Practices
        ◦ Module Introduction
        ◦ Separating Transactional and Reporting Databases
        ◦ Loading too Much Data
        ◦ Committing Data too Frequently
        ◦ ORMs and Abstraction From the Database
        ◦ ORMs and the n+1 Selects Issue
        ◦ Summary

Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top