Creating a Self-Tuning Oracle Database: Automating Oracle9i Dynamic SGA Performance (Oracle In-Focus series) [Paperback]

Donald Burleson (Author)

Book Description

Series: Oracle In-Focus series | Publication Date: August 1, 2003

The dynamic memory features of Oracle9i make it possible to create a self-tuning database. This book explores proven techniques for monitoring the behavior of the Oracle System Global Area (SGA) and provides ways to anticipate upcoming problems and adjust the SGA before a performance problem occurs. Written for senior Oracle database administrators, this guide focuses on proactive tuning and scripting and shows how to collect historical data and use it to develop signatures for all memory areas. Provided are the commands to modify the Oracle9i SGA areas, sample scripts for automating SGA tuning, and access to an online code deport full of interesting Oracle scripts.

Editorial Reviews

About the Author

Donald K. Burleson is the author of 16 Oracle database books and the editor-in-chief of Oracle Internals. He is an Oracle consultant with extensive experience with designing and implementing Oracle8 databases, including systems architecture, project management, data warehouse design, implementation and tuning, tuning massively parallel Oracle databases, Oracle SQL tuning, using Oracle with SAP, and tuning very large Oracle databases. He lives in Kittrell, North Carolina.

Product Details

• Paperback: 160 pages
• Publisher: Rampant Techpress; 1 edition (August 1, 2003)
• Language: English
• ISBN-10: 0972751327
• ISBN-13: 978-0972751322
• Product Dimensions: 9 x 7 x 0.4 inches
• Shipping Weight: 9.6 ounces (View shipping rates and policies)
• Average Customer Review: 3.9 out of 5 stars  See all reviews (8 customer reviews)
• Amazon Best Sellers Rank: #2,300,583 in Books (See Top 100 in Books)

More About the Author

Donald K. Burleson is one of the world's most widely published 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 Emeritus, Burleson has written 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

Most Helpful Customer Reviews

9 of 10 people found the following review helpful:

1.0 out of 5 stars Please Read Technical Criticism of Don Burleson Before Buying, August 20, 2005

By 

Jeremy Smith (Salt Lake City, UT) - See all my reviews
(REAL NAME)   

This review is from: Creating a Self-Tuning Oracle Database: Automating Oracle9i Dynamic SGA Performance (Oracle In-Focus series) (Paperback)

Don Burleson has his name on more Oracle books than (I believe) any other author. However, many other experts on the Oracle database spend a significant portion of their time debunking errors and misinformation that he disseminates in articles and books like these. [...] where a search for "Burleson" will turn up several articles which point out inaccuracies in his articles or statements.

7 of 8 people found the following review helpful:

1.0 out of 5 stars Fluff, September 13, 2005

By 

Shaun Smith "Shaun" (Ireland) - See all my reviews

This review is from: Creating a Self-Tuning Oracle Database: Automating Oracle9i Dynamic SGA Performance (Oracle In-Focus series) (Paperback)

The majority of the information in this book, while looking impressive, is actually so much fluff. A majority of it will either do nothing for performance or make performance worse. Yes, on some systems, some of the suggestions may improve performance, but there is not enough information provided to show you where or when which changes will make which improvements.

Here is an interesting section:

- Plotting the Data Buffer Hit Ratio by Hour of the Day

Isn't that nice. I can graph my buffer hit ratio by hour by day. That is going to help me a lot! The author is still stuck in the ratio mindset and doesn't seem to truly understand how the Oracle SGA actually works. Doesn't show it to the reader anyways.

5.0 out of 5 stars Gobs of Great advice, February 6, 2006

By 

Lorraine de DBA - See all my reviews

This review is from: Creating a Self-Tuning Oracle Database: Automating Oracle9i Dynamic SGA Performance (Oracle In-Focus series) (Paperback)

Statspack is a Godsend tool from Oracle, and this book goes even further than 10g.

This and the previous edition of the book provide DBAs with an excellent introduction into understanding statspack internal tables and great ideas on how to integrate critically important OS statistics into the statspack data gathering process to a self tuning database.

I found this book and the WISE Oracle tool to be invaluable tools that extend statspack capabilities and help to resolve complex performance problems.