Oracle tuning has always been a complex task; however, it has become even more complex as Oracle evolves and yields new techniques for achieving optimal performance in the stressed production environment of today's high-tech world.
Oracle STATSPACK and AWR has introduced a revolution in database tuning. By understanding these time-series tables, we can develop time-series tuning models to predict upcoming outages and dynamically change the instance to accommodate the impending resource changes. Database tuning efforts must become as sophisticated as the databases themselves.
This book strives to show you how to leverage upon the wealth of Oracle performance information so that you can create a robust Oracle database engine, one that maximizes computing resources while minimizing overhead.
If you are seeking theory, this is not the book for you. This book encapsulates the combined knowledge of over a century of hands-on DBA tuning experience, a pragmatic, practical approach for the professional Oracle DBA.
This is not a book for beginners. Targeted at the senior Oracle DBA, this comprehensive book gives you all of the knowledge you need to be successful in tuning even the most complex Oracle database. The code download for this book is packed with ready-to-run scripts to monitor and identify even the most challenging performance issues.
Anonymous
Posted Tue May 16 00:00:00 EDT 2006
This book is a large reference volume, of about 1,000 pages. Rather than trying to read this large book chapter by chapter, I recommend skimming over the sections at first, to see which areas suit your particular needs. For instance, you will likely find Chapter 16 of great value. It's entitled 'Oracle 10g Wait Event Tuning with AWR and ASH.' Or, if you are working with data warehouses, you might check out Chapter 18, 'Oracle Data Warehouse Tuning.' Although there is much discussion about tuning in general, I think its great strength is the focus on Oracle 10g Tuning--especially 'time series metrics,' using the Oracle 10g AWR (Automatic Workload Repository.) In fact, I found the most valuable chapter to be Chapter 9, 'The AWR Time Model Approach.' In this approach, the DBA determines where the database is actually spending its time. After all, that's what performance tuning is all about--where's the time going. The authors explain how to use the time performance views: V$Sys_Time_Model and V$Sess_Time_Model. These views gather cumulative stats for either the entire instance, or per session. There are also references to more traditional tuning techniques, such as gathering proper statistics, SQL tuning, join order, etc. The authors also include chapters on Network Tuning, Disk Tuning, as well as tuning the various cache buffers and pools. Chapter 19 explains how to do performance tuning with the aid of OEM (Oracle Enterprise Manager.) Of special interest to OPS users: Chapter 20 provides an overview of RAC (aka Oracle Parallel Server, OPS). The authors illustrate the 'Cache Fusion' architecture, and discuss the 'data localization' load balancing method. This brief review doesn't come close to doing justice to the huge amount of valuable information in this book. The discussion of the DBA_HIST views is alone worth the price. This is likely the most complete set of Oracle tuning information in a single book. You really have to see it to believe it!
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Overview
Oracle tuning has always been a complex task; however, it has become even ...