You are previewing Forecasting Oracle Performance.
O'Reilly logo
Forecasting Oracle Performance

Book Description

What makes seasoned IT professionals run for cover? Answer: Forecasting Oracle Performance! Craig Shallahamer is an Oracle performance expert with over 18 years of experience. His book is the first to focus not on the problem of solving today's problem, but squarely on the problem of forecasting the future performance of an Oracle database. Other Oracle performance books are good for putting out fires; Craig's book helps you avoid all the heat in the first place.

If you’re an IT practioner who appreciates application over mathematical proofs than you’ll be pleasantly surprised! Each chapter is filled with examples to transform the theory, mathematics, and methods into something you can practically apply. Craig's goal is to teach you about real-word Oracle performance forecasting. Period. There is no hidden agenda.

This book is a kind of training course. After reading, studying, and practicing the material covered in this book, you to be able to confidently, responsibly, and professionally forecast performance and system capacity in a wide variety of real-life situations.

If you are more management-minded (or want to be), you will be delighted with the service level management focus. Forecasting makes good business sense because it maximizes the return on IT investment and minimizes unplanned down time. To those who think forecasting is a waste of money: well...obviously, they’ve never been on the evening news because their company lost millions of dollars in revenue and brand destruction because of poorly performing or unavailable systems.

Without a doubt, you will be equipped to deal with the realities of forecasting Oracle performance. But this book gives you more. Not only will you receive a technical and mathematical perspective, but also a communication, a presentation, and a management perspective. This is career building stuff and immensely satisfying!

What you'll learn

This book is a “how-to” book filled with examples to transform theory and mathematics into something you can practically apply. You will learn how to use a variety of forecasting models, which will enable you to methodically:

  • Help manage service levels from a business value perspective

  • Identify the risk of over utilized resources

  • Predict what component of an architecture is at risk

  • Predict when a system will be at risk

  • Develop multiple risk mitigating strategies to ensure service levels are maintained

  • Characterize a complex Oracle workload

Who this book is for

IT professionals who must ensure their production Oracle systems are meeting service levels, in part, through forecasting performance, identifying risk, and developing solutions to ensure systems are available without wasting budget. Readers include database administrators, IT managers, developers, capacity planners, systems architects, systems integrators.

Table of Contents

  1. Title Page
  2. Dedication
  3. Contents at a Glance
  4. Contents
  5. About the Author
  6. About the Technical Reviewers
  7. Introduction
    1. Why Buy This Book?
    2. What Is the Value to Me?
    3. Who Will Benefit?
    4. How This Book Is Organized
    5. What Notations Are Used?
    6. What Is Not Covered?
  8. CHAPTER 1 Introduction to Performance Forecasting
    1. Risk: A Four-Letter Word
    2. Service-Level Management
    3. Modeling: Making the Complex Simple
    4. Model Types
    5. Challenges in Forecasting Oracle Performance
  9. CHAPTER 2 Essential Performance Forecasting
    1. The Computing System Is Alive
    2. Transactions Are Units of Work
    3. The Response Time Curve
    4. CPU and IO Subsystem Modeling
    5. Method Is a Must
    6. Data Collection
    7. Essential Mathematics
    8. Risk Mitigation Strategies
    9. Summary
  10. CHAPTER 3 Increasing Forecast Precision
    1. Forecasting Gotchas!
    2. Model Selection
    3. Baseline Selection
    4. Response Time Mathematics
    5. Average Calculation
    6. Case Study: Highlight Company
    7. Summary
  11. CHAPTER 4 Basic Forecasting Statistics
    1. What Is Statistics?
    2. Sample vs. Population
    3. Describing Samples
    4. Making Inferences
    5. Precision That Lies
    6. Summary
  12. CHAPTER 5 Practical Queuing Theory
    1. Queuing System Notation
    2. Little's Law
    3. Kendall's Notation
    4. The Queuing Theory Workbook
    5. Queuing Configurations and Response Time Curve Shifts
    6. Challenges in Queuing Theory Application
    7. Summary
  13. CHAPTER 6 Methodically Forecasting Performance
    1. The Need for a Method
    2. The OraPub Forecasting Method
    3. Summary
  14. CHAPTER 7 Characterizing the Workload
    1. The Challenge
    2. Gathering the Workload
    3. Defining Workload Components
    4. Modeling the Workload
    5. Selecting the Peak
    6. Summary
  15. CHAPTER 8 Ratio Modeling
    1. What Is Ratio Modeling?
    2. The Ratio Modeling Formula
    3. Gathering and Characterizing the Workload
    4. Deriving the Ratios
    5. Forecasting Using Ratio Modeling
    6. Summary
  16. CHAPTER 9 Linear Regression Modeling
    1. Avoiding Nonlinear Areas
    2. Finding the Relationships
    3. Determining a Linear Relationship
    4. Dealing with Outliers
    5. Regression Analysis Case Studies
    6. Summary
  17. CHAPTER 10 Scalability
    1. The Relationship Between Physical CPUs and Effective CPUs
    2. How Scalability Is Used in Forecasting
    3. What's Involved in Scalability?
    4. Speedup and Scaleup
    5. Which Forecast Models Are Affected by Scalability?
    6. Scalability Models
    7. Methods to Determine Scalability
    8. Summary
  18. Index