|
 |
|
 |
 |
Oracle Tuning: The Definitive Reference (Oracle in-Focus Series)
|
by Alexey B. Danchenkov, Donald Burleson, and Don Burleson
Sales Rank: 270133
|
Discount: 37 %
List Price: $59.95
$37.77
At Amazon
|
|
Hardcover: 640 pages
Publisher: Rampant Techpress; 1 edition August 1, 2006
Language: English
ISBN-10: 0974448621
ISBN-13: 978-0974448626
Product Dimensions:
9.1 x 7.2 x 2.1 inches
Shipping Weight: 3.7 pounds
Book Description
Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.
About The Author
Alexey B. Danchenkov holds a master's degree in computer science from St. Petersburg State University of Aerospace Instrumentation He started work as an Oracle database administrator at Leaves Inc and worked for several years as a principal Oracle DBA at a large telecommunications company, where he managed very large database and billing systems. Alexey is also the creator of the STATSPACK Viewer software, a popular Oracle graphics package. Donald K. Burleson is one of the world’s top Oracle Database experts with more than 20 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 30 books, published more than 100 articles in National Magazines, and serves as Editor-in-Chief of Oracle Internals. Don is a popular lecturer and teacher and is a frequent speaker at Oracle Openworld and other international database conferences.
Customer Reviews & Comments
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! P.S. I neglected to mention the excellent sketches by Mike Reed. A very nice touch!
Comment | Permalink |
(Report this)
|
Oracle Tuning: The Definitive Reference (Oracle in-Focus Series)
List Price: $59.95
Discount: 37 %
Available from Amazon
Price: $37.77
| |
|
|
|
|
