Book description
Throughout history, advances in technology have come in spurts. A single great idea can often spur rapid change as the idea takes hold and is propagated, often in totally unexpected directions. Exadata embodies such a change in how we think about and manage relational databases. The key change lies in the concept of offloading SQL processing to the storage layer. That concept is a huge win, and its implementation in the form of Exadata is truly a game changer.
Expert Oracle Exadata will give you a look under the covers at how the combination of hardware and software that comprise Exadata actually work. Authors Kerry Osborne, Randy Johnson, and Tanel Pöder share their real-world experience, gained through multiple Exadata implementations with the goal of opening up the internals of the Exadata platform. 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.
Will changes the way you think about managing SQL performance and processing
Provides a roadmap to laying out the Exadata platform to best support your existing systems
Dives deeply into the internals, removing the "black box" mystique and 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 stratigies 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 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
- Title
- Contents at a Glance
- Contents
- About the Author
- About the Technical Reviewer
- Acknowledgments
- Introduction
- 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
- Appendix A: CellCLI and dcli
- Appendix B: Online Exadata Resources
- Appendix C: Diagnostic Scripts
- Index
Product information
- Title: Expert Oracle Exadata
- Author(s):
- Release date: August 2011
- Publisher(s): Apress
- ISBN: 9781430233923
You might also like
book
Expert Consolidation in Oracle Database 12c
Expert Consolidation in Oracle Database 12c is your key to reducing data management costs and increasing …
book
Oracle Database 11g New Features
FOREWORD by Tom Kyte Your Must-Have Guide to Everything New in Oracle Database 11 g Realize …
book
Achieving Extreme Performance with Oracle Exadata
Maximize Oracle Exadata Capabilities Leverage all of the powerful features available in the Oracle Exadata Database …
book
Building Database Clouds in Oracle 12c
An Expert Guide to Building Oracle Database Cloud Infrastructures This is the first complete, practical guide …