Book description
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:
Table of contents
- Cover
- Title
- Copyright
- About IOUG Press
- Contents at a Glance
- Contents
- About the Authors
- 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
- Hardware
-
Flash Cache vs. Flash Disk
- Using Flash Memory as Cache
- Mixed Workload and OLTP Optimizations
- Using Flash Memory for Database Logging
- Using Flash Memory to Accelerate Writes
- Miscellaneous Other WBFC-related Optimizations
- How ESFC and ESFL Are Created
- Enabling the Write-back Flash Cache
- Flash Cache Compression
- Controlling ESFC Usage
- Monitoring
- Summary
- Chapter 6: Exadata Parallel Operations
-
Chapter 7: Resource Management
- Consolidation
- Instance Caging
- Binding Instances to Specific CPUs Using Cgroups
- Oracle 12c THREADED_EXECUTION
- Managing PGA Memory
-
Database Resource Manager
- Creating a CDB Resource Plan
- Creating a (Pluggable) Database Resource Plan
- Using the Scheduler to Change the Resource Plan
- The Wait Event: resmgr: cpu quantum
- Where to Go from Here
- Resource Mapping Priorities
- Resource Limiting
- Other Limiting Parameters
- Consumer Group Mappings Using ORACLE_FUNCTION
- Monitoring the Resource Manager
- Resource Manager Views
- I/O Resource Manager
- Resource Management Directives Matrix
- Summary
-
Chapter 8: Configuring Exadata
- Exadata Network Components
- About the Configuration Process
-
Configuring Exadata
- Step 1: Gathering Installation Requirements
- Step 2: Run Oracle Exadata Deployment Assistant
- Step 3: Create Network VLANs and DNS Entries for Hostnames
- Step 4: Run CheckIP to Verify Network Readiness
- Step 5: Run Cables and Power to Exadata Racks
- Step 6: Perform Hardware Installation
- Step 7: Stage OneCommand Files and Oracle Software
- Step 8: Configure the Operating System
- Step 9: Run OneCommand
- Upgrading Exadata
- Summary
- Chapter 9: Recovering Exadata
- Chapter 10: Exadata Wait Events
- Chapter 11: Exadata Performance Metrics
- Chapter 12: Monitoring Exadata Performance
- Chapter 13: Migrating to Exadata
- Chapter 14: Storage Layout
- Chapter 15: Compute Node Layout
- Chapter 16: Patching Exadata
- Chapter 17: Unlearning Some Things We Thought We Knew
- Appendix A: CELLCLI and DCLI
- Appendix B: Online Exadata Resources
- Appendix C: Diagnostic Scripts
- Appendix D: exachk
- Index
- General
Product information
- Title: Expert Oracle Exadata, Second Edition
- Author(s):
- Release date: August 2015
- Publisher(s): Apress
- ISBN: 9781430262428
You might also like
book
Expert Oracle PL/SQL
Experienced PL/SQL programmers and Oracle developers will learn to master Oracle's procedural extension to industry-standard SQL. …
book
Expert Oracle SQL
Expert Oracle SQL: Optimization, Deployment, and Statistics is about optimizing individual SQL statements, especially on production …
book
Oracle SQL*Plus: The Definitive Guide, 2nd Edition
Despite its wide availability and usage, few developers and DBAs have mastered the true power of …
book
Expert Oracle Database Architecture, Third Edition
" Now in its third edition, this best-selling book continues to bring you some of the …