Sign in  |  Register
Advanced search
Publication Cover

CITATION

Greenwald, Rick; Stackowiak, Robert; Alam, Maqsood; and Bhuller, Mans. Achieving Extreme Performance with Oracle Exadata. US: McGraw-Hill Osborne Media, 2011.

Achieving Extreme Performance with Oracle Exadata

Authors: Rick Greenwald, Robert Stackowiak, Maqsood Alam and Mans Bhuller

Published:  February 2011

eISBN: 9780071752602 0071752609 | ISBN: 9780071752596
Open eBook
  • Contents
  • Foreword
  • Acknowledgments
  • Introduction
  • Part I: Features and Foundations
  • 1 Oracle and Tightly Integrated Hardware and Software Platforms
  • A History of Appliance-Like Computing Solutions
  • Oracle’s Evolution Towards Integrated Hardware and Software
  • Oracle Exadata Database Machine Fundamental Concepts
  • Software Integration and the Oracle Exadata Database Machine
  • Impact of the Platform on Personnel
  • Future Directions
  • Summary
  • 2 Oracle 11g Enterprise Edition Features
  • Data Integrity and Performance
  • Real Application Clusters
  • Automatic Storage Management
  • Partitioning
  • Parallel Execution
  • Data Guard
  • Compression
  • Database Resource Manager
  • Analysis Capabilities
  • Enterprise Manager
  • Data Movement
  • Operating Systems
  • Other Oracle Database 11g Features
  • Summary
  • 3 Exadata Software Features
  • Smart Scan
  • Other Offloaded Processing
  • Exadata Hybrid Columnar Compression
  • Storage Indexes
  • Exadata Smart Flash Cache
  • I/O Resource Manager
  • Interacting with Exadata Storage Server Software
  • Summary
  • 4 Oracle Exadata Database Machine Platform Hardware Components
  • Latency and Balance
  • Oracle Exadata Database Machine Packaging Basics
  • Installation and Initial Deployment Considerations
  • Upgrade Choices for Existing Systems
  • Connecting to the Database Machine
  • Highly Available Hardware Considerations
  • Summary
  • Part II: Best Practices
  • 5 Managing the Exadata Database Machine
  • Exadata Storage Server Architecture
  • Exadata Storage Server Administration
  • Exadata Storage Server Monitoring
  • Summary
  • 6 High Availability and Backup Strategies
  • Exadata Maximum Availability Architecture (MAA)
  • Exadata Database Machine Backup and Recovery Best Practices
  • Summary
  • 7 Deploying Data Warehouses on the Oracle Exadata Database Machine
  • Data Warehousing Basics
  • Generic Oracle Query Optimization
  • Embedded Analytics in Oracle
  • Unique Exadata Features for Optimal Query Response
  • Data Warehousing Compression Techniques
  • The Typical Life of a Query
  • Best Practices for Data Loading
  • Partitioning, Backups, and High Availability in Data Warehouses
  • Data Models, Business Intelligence Tools, and Security
  • Sizing the Platform for Data Warehousing and Justifying Purchase
  • Summary
  • 8 Exadata and OLTP
  • OLTP Workloads and Exadata Features
  • Exadata Hardware and OLTP
  • Oracle 11g and OLTP
  • Exadata Software and OLTP
  • Exadata Nodes and OLTP
  • Exadata as a Complete System
  • Summary
  • 9 Consolidating Databases with the Oracle Exadata Database Machine
  • Why Consolidate?
  • How the Oracle Exadata Database Machine Helps Consolidation
  • Database Server Consolidation
  • Workload Consolidation and Isolation
  • Meeting and Exceeding SLAs
  • Consolidation Design
  • Summary
  • 10 Migrating to the Exadata Database Machine
  • Premigration Steps
  • Migration Steps for Non-Oracle Databases
  • Migration Steps for Oracle Databases
  • Summary
  • A: Exadata Capacity and Performance Specifications
  • Exadata Database Machine Storage Capacity
  • Exadata Storage Server Performance
  • Index