Oracle Consulting Oracle Training Oracle Support Development
Oracle Books
SQL Server Books
IT Books
Job Interview Books
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books

Oracle Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle


Privacy Policy


ISBN: 0-9823061-7-2
ISBN 13: 978-0-9823061-7-8
Library of Congress Number:
214 Pages - Perfect Bind 7.5x9.25
Publication Date -
Shelving Databases/Oracle
Oracle In-Focus Series  # 36

  Oracle Performance Troubleshooting
with Dictionary Internals SQL & Tuning Scripts
Second Edition

Donald K. Burleson, Robin Schumacher 

Retail Price $34.95

Key Features   About the Author Reader Comments
Table of Contents   Index Errata 
Order now at 30% off!

   Only $19.95

Get the Oracle Tuning Library
Save $100 - All four books for only $118.95 
Oracle Tuning: The Definitive Reference 3rd Edition $69.95
Advanced Oracle SQL Tuning: The Definitive Reference $59.95
Oracle Performance Troubleshooting 2nd Ed $34.95
Oracle Tuning Powerscripts $37.95

This second edition is authored by two of the world's most widely read DBAs and Oracle internals experts, Donald Burleson and Robin Schumacher. It is an indispensable guide for any Oracle professional who is looking for real world tuning techniques. 

If you're a DBA who's looking for Oracle scripts and advice on how to get to the heart of critical Oracle performance problems, then you've come to the right place. Our second edition authors focus their incredible knowledge of the Oracle data dictionary into a superb book that shows how to quickly troubleshoot and correct Oracle performance problems.


Key Features

* Learn a troubleshooting methodology for use in analyzing any Oracle database

* Understand ratio-based and bottleneck troubleshooting analysis

* Learn techniques for monitoring and optimizing memory usage

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

* Use scripts to uncover session-related bottlenecks

* Understand techniques for locating and fixing problem SQL


About the Author:


Donald Burleson

Donald K. Burleson is one of the world’s top Oracle Database experts with more than 25 years of full-time DBA experience.  He specializes in creating database architectures for very large online databases and he has worked with some of the world’s most powerful and complex systems.  

A former Adjunct Professor, Don Burleson has written more than 30 books, published more than 100 articles in National Magazines, and serves as Editor-in-Chief of Rampant TechPress. Don is a popular lecturer and teacher and is a frequent speaker at Oracle OpenWorld and other international database conferences.


Free Oracle Tips


Robin Schumacher

  Robin Schumacher serves as the Worldwide Director of Product Management for MySQL, the world's leading open-source database management system.  Robin has over fourteen years experience in database administration, development, monitoring, and tuning with Oracle, DB2, Teradata, Sybase, and Microsoft SQL Server. 

He has authored countless performance-related articles for many database-centric magazines as well as serving as a database software reviewer and feature writer for the likes of Intelligent Enterprise, eWeek, DM Review, and others. 

Table of Contents:
Chapter 1: 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
 Chapter 2: 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
Chapter 4: 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
Chapter 5: 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
Chapter 6: 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
Chapter 7: Workload Analysis Part 1 - 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
Chapter 8: Workload Analysis Part 2 - 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


Reader Comments:




 Copyright © 1996 -2023 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks