ISBN 0-9797951-9-2 ISBN 13: 978-0-9797951-9-0 Library of Congress Number: 1,150 pages: Hardcover - 8x10 PD 511 Shelving: Database/Oracle Oracle in-Focus Series: # 32 Oracle Tuning The Definitive Reference Second Edition Donald K. Burleson Retail Price $69.95 USD/ £45.95 / $75.95 Canadian Order now for 40% off! Only $41.95 (40% off) Get the Complete Oracle Tuning Set Both for only $79.95 - a $119.00 value $69.95 $59.95 Oracle has become the world's most flexible and robust database and along with great power comes great complexity. This complexity requires that the DBA have expert knowledge of Oracle internals.
This book provides a thorough step-by-step approach for holistic Oracle tuning in this challenging information technology era. It represents the knowledge accumulated from tuning thousands of Oracle databases. Oracle tuning has always been a complex task; however, it has become even more complex as Oracle evolves and yields new techniques for achieving optimal performance in the stressed production environment of today’s high-tech world. Oracle STATSPACK and AWR has introduced a revolution in database tuning. By understanding these time-series tables, we can develop time-series tuning models to predict upcoming outages and dynamically change the instance to accommodate the impending resource changes. Database tuning efforts must become as sophisticated as the databases themselves. This book strives to show you how to leverage upon the wealth of Oracle performance information so that you can create a robust Oracle database engine, one that maximizes computing resources while minimizing overhead.
If you are seeking theory, this is not the book for you. This book encapsulates the combined knowledge of over a century of hands-on DBA tuning experience, a pragmatic, practical approach for the professional Oracle DBA. This is not a book for beginners. Targeted at the senior Oracle DBA, this comprehensive book gives you all of the knowledge you need to be successful in tuning even the most complex Oracle database. The code download for this book is packed with ready-to-run scripts to monitor and identify even the most challenging performance issues. See how to access Oracle's time-series performance data.
Learn secrets on how to identify performance signatures and shifting workloads over time. Download the code depot for a gold mine of ready-to-run tuning scripts. See how to analyze historical trends to predict impending performance problems. Get tips for understanding Oracle elapsed-time tuning reports.
Create customized performance alerts to fix a problem before it impedes end-user response time. See how to deploy intelligent Oracle performance optimization. Understand proactive time-series Oracle tuning techniques. Learn secrets for optimizing entire SQL workloads.
About the Author: Donald Burleson Donald K. Burleson is one of the world’s top Oracle Database experts with more than 25 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 more than 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. Free Oracle Tips HTML Text Table of Contents: Using the Online Code Depot Oracle Script Collection Conventions Used in this Book Are you ready to tune? Acknowledgements Preface Chapter 1: Introduction to Oracle Tuning An Introduction to Oracle Tuning Throughput vs.
Oracle 11g Oe Schema Script Download
Response Time Top-down Tuning vs. Bottom-up Tuning Proactive Tuning vs. 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. Hai Lua Errata for fourth printing: The cursorsharing=similar option has been deprecated in Oracle 11g and will be removed in version 12 per MOSC Note 1169017. Errata for second printing: Page 727: It might be appropriate to rebuild an index if the block gets per access is greater than five, since excessive block get can indicate a b-tree structure.
Oracle 11g Sample Schema Scripts Download
Another rebuild condition would be cases where deleted leaf blocks comprise more than 20% of the index structure. Change to: While there is no formula that can predict when an index will benefit from rebuilding, some experts will rebuild indexes when deleted leaf blocks comprise more than 20% of the index structure.