After many months of hard work, I?m happy to report that my premier
book ?Oracle Silver Bullets? is now on the bookstore shelves.
I?ve consolidated the best-of-the-best broad-brush Oracle tuning
techniques into this great book, and I include scripts that will
allow you to quickly find sub-optimal settings within your Oracle
environment! There is nothing like the feeling of making a single
change and seeing massive improvements in Oracle database
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
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.
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.
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.
Key features of the book include:
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
Observe when it is appropriate to use faster
hardware to solve an Oracle performance problem.
See how to find and fix your database-wide
Implement the techniques used by world-class
Oracle tuning experts.
is the definitive collection of professional system-level tuning secrets
for every Oracle professional DBA.
It?s only $19.95 from the publisher, and you can get a copy here: