Expert Oracle Exadata

by Osborne, Kerry; Johnson, Randy; Poder, Tanel

• ISBN13: 9781430233923
• ISBN10: 1430233923
• Format: Paperback
• Copyright: 2011-08-09
• Publisher: Apress

Summary

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.#xA0; Expert Oracle Exadatawill give you a look under the covers at how the combination of hardware and software that comprise Exadata V2 actually work.#xA0; Authors Kerry Osborne and Randy Johnson 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 the 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 take full benefit of the advantages that the platform provides. Changes the way that you'll 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 #x1C;black box#x1D; mystique and showing how Exadata actually works. What you'll learn Configure Exadata from the ground up and optimize it for mixed OLTP/DW workloads Migrate large data sets from existing systems to Exadata efficiently Connect Exadata to external systems and integrate with your existing infrastructure Learn how Resource Manager and IORM work to support consolidation strategies Configure high availability features of Exadata including RAC, ASM, and Dataguard Master tuning strategies utilizing the unique features of Exadata Who this book is for Expert Oracle Exadatais for DBAs 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 needing 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

What Is Exadata?

Offloading / Smart Scan

Hybrid Columnar Compression

Storage Indexes

Exadata Smart Flash Cache

Exadata Parallel Operations

Resource Management

Configuring Exadata

Recovering Exadata

Exadata Wait Events

Understanding Exadata Performance Metrics

Monitoring Exadata Performance

Migrating to Exadata

Storage Layout

Compute Node Layout

Unlearning Some Things We Thought We Knew

Table of Contents provided by Publisher. All Rights Reserved.