ISBN  0-9759135-2-2 ISBN 13 978-0975913529 Library of Congress number: 2005901257 280 pages Perfect bind - 9x7 PD 605 Shelving: Database/Oracle Oracle In-Focus Series # 23

Oracle Silver Bullets Real-world Oracle performance Secrets Donald K. Burleson      Retail Price $27.95 /  £17.95  Order now and get immediate online access to the code depot! Only $19.95 (30% off)       Key Features About the Authors Table of Contents Index Reader Comments Errata       Get the Oracle Tuning Library Save $100 - All four books for only $118.95  Oracle Tuning: The Definitive Reference 3rd Edition $69.95 Advanced Oracle SQL Tuning: The Definitive Reference $59.95 Oracle Performance Troubleshooting 2nd Ed $34.95 Oracle Tuning Powerscripts $37.95

Every Oracle professional should feel the exhilaration of adding a single function-based index and seeing the execution speed cut-in-half for 500 SQL statements. It's these silver bullets that can make you a hero in your shop and amaze your friends and associates.  All Oracle tuning professionals know that they must start by optimizing the database as-a-whole before tuning individual SQL statements. Only after you have tuned the external hardware (disk RAID, network, OS kernel parms) and the instance (indexes, CBO statistics, optimal parameter settings), is it appropriate to tune individual SQL statements and application code. A single change to the optimizer can improve the behavior of hundreds of SQL statements, and database-wide tuning approaches such as adding a missing index, creating a materialized view or adjusting CBO statistics must be done before detailed SQL tuning can happen.  These silver-bullet recommendations have been codified inside the Oracle 10g Automatic Database Diagnostic Monitor (ADDM), and every Oracle professional must recognize the benefits of these important tuning techniques. Oracle consultant Don Burleson shares his in-the trenches Oracle tuning secrets in this concise and practical book.  Packed with actual techniques and tips, Burleson shows you how to perform system-level tuning on all Oracle databases, from small OLTP systems to giant data warehouses. This is the definitive collection of professional system-level tuning secrets for every Oracle professional DBA.

* Learn the secrets used by professional Oracle consultants to get optimal performance fast. * See how adjusting important Oracle parameters can improve database-wide performance. * Understand the importance of proper SQL optimizer configuration. * Observe when it is appropriate to use faster hardware to solve an Oracle performance problem. * See how to find and fix your database-wide bottleneck. * Implement the techniques used by world-class Oracle tuning experts.

About the Author:

Donald Burleson

Donald 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 32 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. Donald Burleson's Resume   Donald Burleson's books   Donald Burleson articles   Free Oracle Tips HTML Text

Reviews:

THE BEST, No wasted effort, September 24, 2006   Reviewer: W. Wheeles (USA) - See all my reviews    All, I have several hundred Oracle books, and have worked with Oracle for sixteen years. This book is beyond words, it is accurate, and most of all it is concise. Finally someone understands that you do not need to write a book over 800 pages for people to read it. The real world examples, problem identification and remediation techniques are the best I have ever seen. I will buy Burleson/RAMPANT from now on. October 15, 2007 I have "Oracle Silver Bullets" and it's a good book. Given that Oracle DBA work is never, ever a case of "Hey, I feel like improving my DB's performance today: I think I'll run this script of Don's in Production and keep my fingers crossed!", I find it odd that anyone with a brain would malign the book, or the idea of Silver Bullets, using the "A newbie could destroy a database with Silver Bullets" argument. A business that has a DBA that would blithely run ANYTHING, no matter who wrote it, on their Production database without having first tested it fully has employed a ticking bomb. It isn't Don's fault that an idiot would buy Silver Bullets and then start running scripts without first checking them for suitability to their own system. Nor is it Don's fault that a business would employ such a plonker. Silver Bullets are IDEAS and APPROACHES that MAY work, but have to be TESTED... ALWAYS!!!! Common sense is any professional's primary asset. To whinge about idiots hamfistedly using others' published ideas, suggestions and insights is both silly and, I think, disingenuous. Regards, Richard XXXX Oracle DBA

Table of Contents:

CHAPTER 1- Oracle Silver bullets   CHAPTER 2 - The Oracle DBA of the 21st Century   CHAPTER 3 - Proactive Tuning and Silver Bullets   CHAPTER 4 - The Silver Bullet Hierarchy   CHAPTER 5 - Very Large Database Silver Bullets   CHAPTER 6 - Indexing Silver Bullets

CHAPTER 7 - Instance Parameter Silver Bullets   CHAPTER 8 - Table Structure Silver Bullets   CHAPTER 9 - Segment Structure Silver Bullets   CHAPTER 10 - Oracle SQL Silver Bullets   CHAPTER 11 - Oracle Hardware Silver Bullets

Page 172 - 2nd paragraph from the bottom the sentence - "When data using the new cbo feature cpu_cost in Oracle10g,..."

Page 16 -  “complex DSS queries” should read “complex queries”

Page 35 - “/dbms_schedule/” should read “/dbms_scheduler/”

Page 103 - The following sentence is backwards: 

When the clustering factor is close to the number of data blocks the column value is not row ordered. When the clustering_factor approaches the number of rows on the table, the table rows are synchronized with the index.

It should read:

When the clustering factor is close to the number of data blocks the column values are row ordered. When the clustering_factor approaches the number of rows on the table, the table rows are increasingly not synchronized with the index.

Page 169 - “Non-relation databases” should read Non-relational databases”

Page 172 - “new /cpu_cost /parameter in” should read “new CBO feature
/cpu_cost/ in Oracle 10g”

Page 229 - add to the bottom of the 2^nd code listing this line: “exec dbms-stats”

The dba_hist_sql_plan table was incorrectly called dba_hist_sqlplan.
 

Index Topics: