×

Uh-oh, it looks like your Internet Explorer is out of date.

For a better shopping experience, please upgrade now.

Oracle Tuning: The Definitive Reference
     

Oracle Tuning: The Definitive Reference

5.0 1
by Donald K. Burleson
 

See All Formats & Editions

Oracle has become the world's most flexible and robust database and along with great power comes great complexity. This complexity requires that the DBA have expert knowledge of Oracle internals. This book provides a thorough step-by-step approach for holistic Oracle tuning in this challenging information technology era. It represents the knowledge accumulated from

Overview

Oracle has become the world's most flexible and robust database and along with great power comes great complexity. This complexity requires that the DBA have expert knowledge of Oracle internals. This book provides a thorough step-by-step approach for holistic Oracle tuning in this challenging information technology era. It represents the knowledge accumulated from tuning thousands of Oracle databases.

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.

Product Details

ISBN-13:
9780982306130
Publisher:
Rampant TechPress
Publication date:
02/27/2014
Pages:
828
Product dimensions:
7.50(w) x 9.25(h) x 1.64(d)

Meet the Author

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.

Customer Reviews

Average Review:

Post to your social network

     

Most Helpful Customer Reviews

See all customer reviews

Oracle Tuning: The Definitive Reference 5 out of 5 based on 0 ratings. 1 reviews.
Guest More than 1 year ago
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!