View Larger Image	Donald K. Burleson Rampant TechPress, Paperback, Published June 2005, 267 pages, ISBN 0975913522
	List Price: $27.95 Our Price: $17.50 You Save: $10.45 (37% Off)
	Availability: Out-Of-Stock

Write a Review and tell the world about this title!

People who purchase this book frequently purchase:

• Oracle Wait Interface: A Practical Guide to Performance Diagnostics & Tuning; Kirtikumar Deshpande, et al, $31.50, 41% Off!
• Oracle Job Scheduling: Creating robust task management with dbms_job and Oracle 10g dbms_scheduler; Dr. Timothy S Hall, $11.50, 32% Off!
• Expert Oracle Database Architecture: 9i and 10g Programming Techniques and Solutions; Thomas Kyte, $30.50, 39% Off!
• Oracle Tuning: The Definitive Reference; Alexey B. Danchenkov, et al, $37.95, 37% Off!

• Databases : Oracle

• Rampant TechPress

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.

Table of Contents

CHAPTER 1 - Oracle Hardware Silver Bullets

The top-down approach to Oracle tuning

The one-hour Oracle triage technique
Bottleneck analysis
Server stress analysis
Instance analysis
Network analysis
Disk I/O analysis
Tuning when you can't touch the code
Fixing sub-optimal code with faster hardware

CHAPTER 2 - Disk sub-system Tuning

Identify I/O bottlenecks
Applying solid-state disk
Adjusting disk RAID

CHAPTER 3 - Oracle Parameter Tuning

Change the CBO optimizer parameters
optimizer_index_cost_adj
optimizer_index_caching
optimizer_mode
Initialize missing Oracle instance parameters

CHAPTER 4 - Oracle RAM Tuning

Adjust the sizes of the SGA pools
Implement the KEEP pool for small-table full-scanned tables
Utilize multiple blocksizes and multiple data caches

CHAPTER 5 - Oracle SQL Optimizer Tuning

Fix missing CBO statistics
Replace an obsolete statistics gathering method
Create bitmap indexes
Add missing indexes
Employ materialized views

CHAPTER 6 - Tuning the Shared Pool

Evaluating the library cache
Using cache cursors
Implement cursor_sharing
Removing excessive SQL parsing

CHAPTER 7 - Server silver bullets

Identify incorrect kernel parameters
Oracle Windows issues (screen savers, virus scanning, file server configuration)
Configuring direct I/O

CHAPTER 8 - Network silver bullets

Using network sniffers
Adjusting SDU and TDU
Implementing tcp.nodelay

CHAPTER 9 - Table & Index silver bullets

Adjust freelists and freelist groups
Adjust maxtrans
Implement bitmap freelists (automatic segment space management)
Using locally-managed tablespaces
Table reorganization
Index rebuilding

About the Author

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.

Feb 27, 2008     Earl Shaffer - OracleMan Consulting from USA
Very practical and informative
I bought this after hearing about how practical it was. I read it and used it and I am very happy I have it.

Many books have a few examples and that is about it. Others reproduce the SQL syntax from the Oracle manuals. This book is about problem/fix, situation/remedy, etc. Very practical.

Bottom line - it has helped me with real world problems. I bet it would help any production DBA. I recommend you get it.

Oct 2, 2005     Robert F.
Advice for the real world
I want to hear about how to tune my database from folks who do it everyday and I am weary of theory books. If you do not want theory this is the book to get because it has lessons for tools that work in other Oracle shops. And what an eye opener that single changes can have such big inpacts on performnce of Oracle system.

Forgot your password? FAQs Shipping Options Returns Your Orders Your Account