- ホーム
- > 洋書
- > 英文書
- > Computer / Databases
Full Description
The Practical, Authoritative, 360-Degree Technical Guide to Oracle Exadata: From Setup to Administration, Optimization, Tuning, and TroubleshootingThe blazingly fast Oracle Exadata Database Machine is being embraced by thousands of large-scale users worldwide: by governments, the military, enterprise organizations, cloud service providers, and anyone who needs extreme performance. Now, Oracle Exadata Expert's Handbook provides authoritative guidance to running Oracle Exadata with maximum reliability, effectiveness, performance, and efficiency.Six renowned Oracle technology experts have brought together core technical information, experience, best practices, and insider tips in a concise reference. Covering both 11g and 12c versions of Oracle Exadata software, they deliver hands-on coverage of best practices, setup, migration, monitoring, administration, performance tuning, and troubleshooting. Whether you're an Oracle Exadata DBA, DMA, architect, or manager, you need these insights.Get a 360-degree overview of the Oracle Exadata Database MachineEfficiently deploy RAC within the Oracle Exadata ecosystemFully leverage Storage Cell's extraordinary performance, via Offloading, Smart Scans, and Hybrid Columnar CompressionManage Exadata with OEM 12c: perform setup, configuration, asset/target discovery, and day-to-day administrationTune Oracle Exadata for even better performancePerform Exadata Backup/Recovery/DR with RMAN and Data GuardMigrate to Oracle Exadata from other platformsUse Oracle Exadata with the ZFS Storage ApplianceConsolidate within the Exadata Database Cloud
Contents
Preface xviiAcknowledgments xixAbout the Authors xxiiiAbout the Technical Reviewers and Contributors xxviiChapter 1: 360-Degree Overview of Exadata 1An Exadata Synopsis 2Hardware Architecture 5Software Architecture 7Models and Configuration Options 9Examining an Exadata Machine 35Summary 37Chapter 2: Real Application Clusters (RAC) in Exadata 39The Significance of RAC in Exadata 40An Overview of RAC 41Setting Up RAC Clusters in Exadata 43Operational Best Practices 45Managing RAC with OEM 12c 49Common Utilities and Commands 50Troubleshooting and Tuning RAC 55Summary 59Chapter 3: The Secret Sauce: Exadata Storage Cells 61An Overview of Exadata Storage Server 61Storage Architecture and Formulation 72Disk Architecture in Non-Exadata 74Disk Architecture in Exadata 74System Users for Cell Administration 77Managing the Cell Server 82Troubleshooting the Cell Server 83Storage Cell Startup and Shutdown 85Solving Disk Problems 87Enforcing Cell Security 89Summary 92Chapter 4: Flash Cache, Smart Scans, and Cell Offloading 93Concepts of Exadata Flash Cache 93Storage Server and Flash Cache 95The Database and Flash Cache 99Summary 120Chapter 5: Exadata Compression: HCC Demystified 121Columnar Storage Models 122Oracle Implementation of DSM-Hybrid Columnar Compression 125HCC and Performance 131HCC and DML 140HCC and Locking 144Practical Uses of HCC 147Summary 148Chapter 6: Oracle Database 12c and Exadata 14912c Partitioning Features 149New 12c Optimizer Features 157Information Lifecycle Management 164Application Continuity 167Multitenant Architecture 168Exadata Software Updates 183Summary 183Chapter 7: Exadata Networking: Management and Administration 185Exadata Network Components 185The Role of the InfiniBand Network 186Network Architecture 187Network Setup Requirements 188Troubleshooting Tools and Utilities 190Log Files Collection 194Integrated Lights Out Manager 195OEM Cloud Control 12c 197Summary 199Chapter 8: Backup and Recovery and Data Guard 201RMAN Disk-to-Disk Backups 202Data Guard 216Far Sync 233Switchover Considerations 242Summary 244Chapter 9: Managing Exadata with OEM 12c 245Exadata Targets Discovery 246Oracle Exadata Plugins 248Exadata Database Machine Discovery 250Exadata Components 260Summary 265Chapter 10: Migrating to Exadata 267Exadata Implementation Lifecycle 267Phase I: Architectural Strategy 268Phase II: Planning and Design 277Phase III: Migration Testing 287Exadata Migration Best Practices 290Summary 291Chapter 11: Upgrading and Patching Exadata and ZFS Storage Appliance 293Planning an Exadata and ZFS Upgrade 294Quarterly Full Stack Download 297Patching Tools and Processes 297Oracle Patch Types 302Exadata High Availability Upgrades 305Reviewing Settings with Exachk 306Exadata Full Stack Upgrade 307ZFS Upgrade 333Summary 336Chapter 12: ZFS Storage Appliance for Exadata 337ZFS Family Line 338Increased Storage Capacity 340ZFSSA Browser User Interface 342Creating NFS Shares 343Preparing Exadata for Direct NFS 345Other Industry Use Cases 355Learning on the Simulator 355Summary 356Chapter 13: Exadata Performance Tuning 357Oracle Performance Tuning 357Application Design for Exadata 362Database Design for Exadata 364SQL Tuning for Exadata 372Exadata RAC Tuning 374Optimizing Exadata I/O 386Summary 388Chapter 14: Database Consolidation on Exadata 389Database Consolidation Models 389Exadata Consolidation Planning 390Grouping Applications 391Evaluating Sizing Requirements 393Setting Up Exadata for Consolidation 394Isolation Management 40512c Pluggable Database 410Summary 411Chapter 15: Exadata Smart Flash Cache in Depth 413Solid-State Disk Technology 413Exadata Flash Hardware 422Exadata Smart Flash Cache 423Exadata Smart Flash Logging 433Smart Flash Cache WriteBack 439Summary 443Chapter 16: Advanced Exadata Flash Configuration 445Using Flash as Grid Disks 445Flash Tablespace versus Flash Cache 451Storage Tiering Solutions 458Summary 463Chapter 17: Exadata Tools and Utilities 465Exadata Diagnostic Tools 465InfiniBand Network Diagnostic Tools 469Other Useful Exadata Commands 475Monitoring Exadata Storage Cells 484Summary 491Index 493
