Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 







Advanced Oracle Troubleshooting Training Course

A three day on-site Advanced Oracle Troubleshooting class

© 2016 by Burleson Corporation


This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices

Optional supplemental mentoring


Key Features

* Learn diagnostic and troubleshooting techniques

* Provides a winning performance methodology for use in analyzing any Oracle database

* learn a winning performance methodology for use in analyzing any Oracle database

* See how to properly use ratio-based and bottleneck analysis

* Get insight into how to design a fast-running database from the ground up

* Learn methods for making storage and reorganization problems a thing of the past

* Get new techniques for monitoring and optimizing memory usage

* See how to quickly pinpoint and resolve I/O hotspots at the database, storage and object level

* Understand  improved methods for uncovering session-related bottlenecks

* Get expert tips and techniques for locating and fixing problem SQL


Course Description

This Oracle advanced troubleshooting course is an intensive 3-day course is designed to provide Oracle professionals with an in-depth understanding of how to diagnose and troubleshoot an Oracle database.

exercises are used to illustrate Oracle troubleshooting techniques and the students will receive a package of advanced troubleshooting scripts to aid them in diagnosing and isolating the root cause of any Oracle problem.

Book Required

Oracle Performance Troubleshooting

with Dictionary Internals SQL & Tuning Scripts

Robin Schumacher

ISBN: 0-9727513-4-3


This advanced Oracle troubleshooting training class is designed for working Oracle professionals who wish to learn advanced techniques for diagnosing and repairing Oracle problems.

The course assumes a basic knowledge of Oracle DBA management and administration, relational database concepts, SQL syntax, and basic Oracle architecture.

Curriculum Design

This advanced Oracle troubleshooting training course was designed by Donald K. Burleson.  Author of more than 30 database books, Burleson was chosen by Oracle Press to write five authorized editions, including Oracle High-Performance SQL tuning. Burleson has over two decades of real-world DBA experience and shares his Oracle troubleshooting secrets in this advanced Oracle troubleshooting  training.

Learning Objectives:

The primary objective of this Oracle troubleshooting training course is to provide each student with the knowledge to quickly diagnose and troubleshoot any acute Oracle performance problem.  The student will gain confidence in their Oracle troubleshooting skills via exercises designed to highlight advanced troubleshooting techniques and scripts.

Advanced Oracle Troubleshooting Training Course


A three day on-site Oracle advanced troubleshooting training class
Copyright © 2016 by Burleson Corporation

Accurately Measuring Performance

What’s the right way to really measure the overall performance of a database and how is this accomplished when you have a large database farm to manage?  This chapter answers these questions and highlights the critical areas a DBA needs to stay focused on at all times. 

  • Modeling Peak Efficiency
  • Gauging Availability with v$ views
  • Gauging Transaction Speed with v$sqlarea
  • Availability Impact
  • Speed Impact

Correcting Foundational Flaws

Although some may disagree, most database gurus feel that laying the proper physical foundation for your database is the way to get the most performance bang for the buck. This chapter discusses the importance of proper physical design and helps DBAs diagnose physical design performance issues.

  • The Impact of Solid Database Design with v$bh analysis
  • The Number One Contributor to Database Performance
  • The Link Between Design and Performance Tuning with materialized views
  • Boosting Database Performance Through Design
  • How to Pinpoint Database Design Errors with v$sql analysis

Chapter 3: Optimizing Storage

Storage-related headaches are often the single biggest contributor to database downtime.  This chapter discusses the best ways to avoid storage problems through proactive planning and also provides fast diagnostic procedures that can be used to eliminate space problems before they reach critical mass.

  • The Contribution of Storage to Performance with RAID
  • Storage Design Considerations
  • Smart Ways to Avoid Database Downtime
  • Critical Storage Headaches to Avoid
  • Removing Storage-related Performance Vampires

Maximizing Oracle SGA Memory

Throwing more memory at a database used to be an acceptable form of performance tuning, but such is not the case any longer.  This chapter shows how to use memory correctly and also provides techniques and scripts to troubleshoot memory-related performance problems the right way.    

  • When Does Less Become More?
  • New Performance-Boosting Memory Options
  • How to Keep Data Where You Want It
  • How to Keep Code Where You Want It
  • Uncovering Memory Hogs

Pinpointing I/O Hotspots

How can a DBA quickly find the I/O bottlenecks in their database and then make them permanently go away?  This chapter outlines a bulletproof roadmap that any DBA can use to get a handle on their database I/O.  

  • Starting with Global Basics
  • Determining Global Object Access Patterns
  • Examining Storage-Level Statistics
  • Uncovering the Hot Database Objects
  • Locating I/O Resource Hogs
  • Miscellaneous I/O Considerations

Eliminating Critical Bottlenecks

A DBA needs to keep their database running effectively at all times, but sometimes this is easier said than done.  This chapter shows how to quickly find and eliminate critical bottlenecks in a database that may be causing painful slowdowns.

  • Using Ratio-based Methods
  • Using Wait-Event Methods
  • Other Bottleneck Identification Techniques
  • The Winning Solution

Uncovering Problem Sessions

Left unchecked, a few rogue users in a database can make life miserable for everyone else.  This chapter provides all the right ammunition a DBA needs to ferret out these problem sessions so that their database is kept secure and running well at all times. 

  • Uncovering Security Holes
  • Finding Storage Hogs
  • Locating Top Resource Sessions
  • Pinpointing Sessions with Problem SQL

Identifying Problem SQL

If it’s true that eighty-percent of a database’s performance is derived from the SQL code running within it, then a DBA has to know how to find and correct the problem SQL in their critical databases.  This chapter provides everything a DBA needs to quickly pinpoint the SQL code in their database that needs critical attention.  

  • Locating the Top SQL Contributors
  • Pinpointing Bad SQL
  • New Techniques for Analyzing SQL Execution
  • SQL Tuning Roadmap


Oracle Training at Sea
oracle dba poster

Follow us on Twitter 
Oracle performance tuning software 
Oracle Linux poster


Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2020

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.