- Hardcover: 269 pages
- Publisher: Apress; 1st Corrected ed., Corr. 3rd printing edition (August 30, 2007)
- Language: English
- ISBN-10: 1590598024
- ISBN-13: 978-1590598023
- Product Dimensions: 7 x 0.7 x 10 inches
- Shipping Weight: 1.5 pounds (View shipping rates and policies)
- Average Customer Review: 6 customer reviews
- Amazon Best Sellers Rank: #2,705,899 in Books (See Top 100 in Books)
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Forecasting Oracle Performance 1st Corrected ed., Corr. 3rd printing Edition
Use the Amazon App to scan ISBNs and compare prices.
The Amazon Book Review
Author interviews, book reviews, editors picks, and more. Read it now
Customers who bought this item also bought
About the Author
Craig Shallahamer has over 18 years of experience working in Oracle, empowering others to maximize their Oracle investment, efficiencies, and performance. In addition to being a consultant, researcher, writer, and keynote speaker at Oracle conferences, he is the designer and developer of OraPub's Advanced Reactive Performance Management and Forecasting Oracle Performance classes. He is also the architect of HoriZone, OraPub's service-level management product.
Browse award-winning titles. See more
Top customer reviews
There was a problem filtering reviews right now. Please try again later.
This book was not an easy read for me. It took several weeks (I admit, I was not reading it regularly) to read the book fully. I will have to do some real world exercises so I know how to apply the techniques in the book. It will be a while before I am fully conversant with the topics and the methods, but I am sure I will be much better off in the field of forecasting.
Without a doubt, this is one of the best books I have read in Oracle performance and planning topic.
Before starting this book I had a feeling that it was little bit opposed to the secret of Stephen Hawking books where he had just used one famous formula E=mc^2. This book looked full of overwhelming mathematical formulas.
However, author presented material in a very easy to digest way. All formulas are absolutely necessary for understanding the Forecasting approaches.
These approaches are universal and don't depend on particular Oracle version. It's everything about applying proper forecasting models depending on the Forecasting question and workload data collected against complex Oracle environment. It's very straightforward if you read it fully.
It's MUST for those who are facing questions like" What would happen if the workload was doubled in three months? Does it make sense to buy 6 more CPUs to maintain agreed SLA? etc etc.
Book audience is
1) Oracle DBAs
2) Project managers/ Architects
3) Oracle developers
This book is quite unique on a market, because most of existing Oracle books describe Performance Troubleshooting.
Knowledge from this book will not become obsolete with new version of Oracle.
This is not a trivial book, but it's an excellent book for performance tuning, a worthy book for the worthy scholar.
Oracle STATSPACK and the automated workload repository have provided a gold mine for the Oracle DBA to forecast future performance, and this is a great "get started" book to the statistical techniques that are required to perform performance forecasting.
Good books, like good professionals, are rare. This is why I have developed a tendency to choose carefully before buying one and, in the Oracle area in particular, I can smell the author's intellectual honesty and trustworthiness from the first page.
Forecasting Oracle Performance is one of those. I enjoyed the fluid style and closeness of the author. I enjoyed the simplicity and clarity, almost reminding me of Wittgenstein's famous quote ("everything that can be said can be said clearly"). I also enjoyed these short touches of humanism (cf Erlang Krarup's life).
On the forecasting subject, I liked the book construction and the quality of the examples.
Chapter 1 gives a landscape picture of Oracle forecasting and puts the reader in scope and context.
Chapter 2 introduces the reader to the basics of forecasting and the basic concepts over which the book is built: Transactions, response time, arrival time and basic formulas are described here.
Chapter 3 shows the limits of basic forecasting (essential formulas) and the problem of baseline and model selection. It shows how to increase forecasting precision with ErlangC or weighted averages. Most importantly, it shows why it is essential to understand the concepts and implications of the application of a given formula, model or method. The author is very careful in the choice of terms and always clears potential ambiguities. Those who know how difficult it can be to forecast will appreciate it.
Chapter 4 introduces to statistics applied to forecasting.
Chapter 5, on practical queuing theory, is probably the biggest chapter of the book. After a brief introduction to queuing theory, Little's law and Kendall notation, this chapter provides such a diverse set of examples (27!) making the topic very intuitive to non-specialists.
Chapters 6 & 7 describe forecasting methodology and workload characterization. The first describes the steps across a solid performance forecasting methodology, from the initial question to the actual forecast. The second deals with workload characterization: how to get system and Oracle data, how to choose the source and peak. It describes the workload modelling and the risks of data collection.
Chapters 8 and 9 are about models: ratio and linear regression models. They describe their respective foundations, limitations and advantages. Each chapter also contain several examples and case studies to illustrate the subject.
The last chapter deals with scalability models and their relationship with forecasting models.
Overall, I found this book very useful. You will find additional resources at the author's website (there is also a discussion forum on forecasting). The errata page is always up-to-date and some examples have even been extended. Great work!