Expert Oracle Exadata

ISBN-13: 9781430233923 / Angielski / Miękka / 2011 / 588 str.

Kerry Osborne; Randy Johnson; Tanel Poder

Opis

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 POder 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.

• 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

Spis treści

1. What Is Exadata?
2. Offloading / Smart Scan
3. Hybrid Columnar Compression
4. Storage Indexes
5. Exadata Smart Flash Cache
6. Exadata Parallel Operations
7. Resource Management
8. Configuring Exadata
9. Recovering Exadata
10. Exadata Wait Events
11. Understanding Exadata Performance Metrics
12. Monitoring Exadata Performance
13. Migrating to Exadata
14. Storage Layout
15. Compute Node Layout
16. Unlearning Some Things We Thought We Knew

O autorze

Kerry Osborne began working with Oracle (version 2) in 1982. He has worked as both a developer and a DBA. For the past several years he has been focused on understanding Oracle internals and solving performance problems. He is an OakTable member and an Oracle Ace Director.. Kerry is a frequent speaker at Oracle conferences. He is also a co-founder of Enkitec, an Oracle-focused consulting company headquartered in Dallas, Texas. He blogs at kerryosborne.oracle-guy.com.