Forecasting Oracle Performance
Contained in this book are, dare I say, secrets—really. There is a mystery surrounding topics like forecasting, performance management, capacity planning, performance modeling, p- formance prediction, and managing service levels. Add into the mix a dynamic Oracle system, and you have realities that bring professional capacity planners to their knees. In the pages of this book are the secrets I’ve uncovered and discovered through more than 20 years of working with literally thousands of IT professionals around the world. My goal is to expose these secrets as plainly and completely as I possibly can. One of these secrets is unraveling the relationship between service-level management and forecasting Oracle performance. The difficulty lies in the breadth and depth of each of these topics. They are both massive and fork off in a variety of directions. If you are able to bring the two together, you will be able to architect, build, use, and explain to others how they can better manage the delivery of IT services. I will, as clearly as I can throughout this book, present both these areas of IT and then weave them together. The result will leave you with a confident understanding so you can deal with the realities of IT.
What people are saying - Write a review
Other editions - View all
activity Amdahl application arrival rate average service baseline batch processes batch-to-CPU ratio benchmark calculate chapter complex computing system concurrent batch confidence interval confidence level configuration CPU subsystem CPU utilization data points database server determine devices effective CPUs Erlang essential forecasting formulas example faster CPUs forecast model forecast precision forecasting Oracle performance gathering graph hardware input IO subsystem linear regression look math McDonald’s ms/trx multiple normal distribution number of CPUs number of servers OLTP users operating system Oracle database Oracle system Oracle workload Oracle’s outliers peak physical CPUs plot queue length queue traffic queuing system queuing theory ratio modeling regression analysis regression formula response time curve result risk scalability model servers per queue service levels shown in Figure simple simulation skew spreadsheet SQL*Plus standard deviation statistics study question super-serial Table throughput transaction trx/ms trx/s v$sesstat validation variables vendor workload data workload increase workload model λ λ
Page xiii - Performance, and the lead designer and developer of the Hotsos PD101 course. Prior to co-founding Hotsos in 1999, he served for ten years at Oracle Corporation as one of the company's leading system performance experts. At Oracle, he also founded and served as vice president of the 80-person System Performance Group. He has educated thousands of Oracle consultants, support analysts, developers, and customers in the optimal use of Oracle technology through commitment to writing, teaching, and speaking...
Page xviii - ... use it as a singular noun. Latin had taken the word from Greek mathematikos, which in turn was based on mathesis. That word, which was also borrowed into English but is now archaic, meant "mental discipline" or "learning," especially mathematical learning.