Expert.Oracle.Exadata.2nd.Edition.1430262419下载

Title: Expert Oracle Exadata, 2nd Edition Author: Andy Colvin, Frits Hoogland, Karl Arao, Kerry Osborne, Martin Bach, Randy Johnson, Tanel Põder Length: 672 pages Edition: 2 Language: English Publisher: Apress Publication Date: 2015-08-13 ISBN-10: 1430262419 ISBN-13: 9781430262411 Expert Oracle Exadata, 2nd Edition opens up the internals of Oracle's Exadata platform so that you can fully benefit from the most performant and scalable database hardware appliance capable of running Oracle Database. This edition is fully-updated to cover Exadata 5-2 and Oracle Database 12c. If you're new to Exadata, you'll soon learn that it embodies a change in how you think about and manage relational databases. A key part of that change lies in the concept of offloading SQL processing to the storage layer. In addition there is Oracle's engineering effort in creating a powerful platform for both consolidation and transaction processing. The resulting value proposition in the form of Exadata has truly been a game-changer. Expert Oracle Exadata, 2nd Edition provides a look at the internals and how the combination of hardware and software that comprise Exadata actually work. Authors include Martin Bach, Andy Colvin, and Frits Hoogland, with contributions from Karl Arao, and built on the foundation laid by Kerry Osborne, Randy Johnson, and Tanel Poder in the first edition. They share their real-world experience gained through a great many Exadata implementations, possibly more than any other group of experts today. Always their goal is toward helping you advance your career through success with Exadata in your own environment. This book is intended for readers who want to understand what makes the platform tick and for whom—"how" it does what it is does is as important as what it does. By being exposed to the features that are unique to Exadata, you will gain an understanding of the mechanics that will allow you to fully benefit from the advantages that the platform provides. This book changes how you think about managing SQL performance and processing. It provides a roadmap to successful Exadata implementation. And it removes the "black box" mystique. You'll learn how Exadata actually works and be better able to manage your Exadata engineered systems in support of your business. This book: Changes the way you think about managing SQL performance and processing Provides a roadmap to successful Exadata implementation Removes the "black box" mystique, showing how Exadata actually works What you’ll learn Configure Exadata from the ground up Optimize for mixed OLTP/DW workloads Migrate large data sets from existing systems Connect Exadata to external systems Support consolidation strategies using the Resource Manager Configure high-availability features of Exadata, including Real Application Clusters (RAC) and automatic storage management (ASM) Apply tuning strategies utilizing the unique features of Exadata Who this book is for Expert Oracle Exadata, 2nd Edition is for database administrators and developers who want to understand what makes Exadata unique so that they can take advantage of all the platform has to offer. It is also for anyone who needs to plan and execute migrations of systems to the Exadata platform. Finally, the book will be invaluable to those who support and maintain such systems. Table of Contents Chapter 1. What Is Exadata? Chapter 2. Offloading / Smart Scan Chapter 3. Hybrid Columnar Compression Chapter 4. Storage Indexes Chapter 5. Exadata Smart Flash Cache Chapter 6. Exadata Parallel Operations Chapter 7. Resource Management Chapter 8. Configuring Exadata Chapter 9. Recovering Exadata Chapter 10. Exadata Wait Events Chapter 11. Understanding Exadata Performance Metrics Chapter 12. Monitoring Exadata Performance Chapter 13. Migrating to Exadata Chapter 14. Storage Layout Chapter 15. Compute Node Layout Chapter 16. Unlearning Some Things We Thought We Knew Chapter 17. Patching Appendix A: CELLCL and DCLI Appendix B: Online Exadata Resources Appendix C: Diagnostic Scripts Appendix D: Exachk