相關主題
商品描述
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 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 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
- 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
商品描述(中文翻譯)
歷史上,技術的進步往往是突發性的。單一的偉大想法常常能促進快速變革,因為這個想法被接受並推廣,通常會朝著完全意想不到的方向發展。Exadata 代表了我們對關聯式資料庫的思考和管理方式的重大變革。這一變化的關鍵在於將 SQL 處理卸載到儲存層的概念。這一概念是一個巨大的勝利,而其以 Exadata 形式的實現確實是遊戲規則的改變者。
Expert Oracle Exadata 將讓您深入了解組成 Exadata 的硬體和軟體的實際運作。作者 Kerry Osborne、Randy Johnson 和 Tanel Põder 分享了他們在多次 Exadata 實施中獲得的實際經驗,目的是揭示 Exadata 平台的內部運作。本書適合那些希望了解該平台運作原理的讀者,對他們來說,'如何' 做到這一點與它所做的事情同樣重要。通過接觸 Exadata 獨特的功能,您將能夠理解其機制,從而充分利用該平台所提供的優勢。
- 將改變您對管理 SQL 性能和處理的思考方式
- 提供一個路線圖,以最佳方式佈局 Exadata 平台以支持您現有的系統
- 深入探討內部運作,消除“黑箱”神秘感,展示 Exadata 實際運作的方式
您將學到什麼
- 從零開始配置 Exadata
- 針對混合 OLTP/DW 工作負載進行優化
- 從現有系統遷移大型數據集
- 將 Exadata 連接到外部系統
- 使用資源管理器支持整合策略
- 配置 Exadata 的高可用性功能,包括實際應用集群 (RAC) 和自動儲存管理 (ASM)
- 應用利用 Exadata 獨特功能的調整策略
本書適合誰
Expert Oracle Exadata 適合希望了解 Exadata 獨特之處的資料庫管理員和開發人員,以便他們能夠利用該平台所提供的所有優勢。它也適合需要計劃和執行系統遷移到 Exadata 平台的任何人。最後,本書對於支持和維護這些系統的人來說將是無價的。
目錄
- 什麼是 Exadata?
- 卸載 / 智能掃描
- 混合列壓縮
- 儲存索引
- Exadata 智能快閃快取
- Exadata 並行操作
- 資源管理
- 配置 Exadata
- 恢復 Exadata
- Exadata 等待事件
- 理解 Exadata 性能指標
- 監控 Exadata 性能
- 遷移到 Exadata
- 儲存佈局
- 計算節點佈局
- 重新學習我們認為已知的某些事物