Achieving Extreme Performance with Oracle Exadata by Greenwald, Rick -- Read -- Imperial Library of Trantor

Index

Cover Page Achieving Extreme Performance with Oracle Exadata Copyright Page Dedication About the Authors 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

Locks and Lock Management MVRC Flashback

Real Application Clusters

What Is RAC? RAC and Availability RAC and Scalability Cache Fusion Allocating Resources and RAC RAC One RAC and the Exadata Database Machine

Automatic Storage Management

What Is ASM? ASM and Performance ASM and Availability ASM and Management

Partitioning

What Is Partitioning? Partitioning Types Other Benefits Partitioning and the Exadata Database Machine

Parallel Execution

What Is Parallel Execution? What Can Be Parallelized? How Parallelism Works Partition-wise Parallel Joins How Do You Configure Parallel Execution? Degree of Parallelism Modifying DOP Ensuring DOP Parallelism and RAC In-memory Parallel Execution Parallelism and Exadata

Data Guard

What Is Data Guard? How Can Data Guard Be Implemented? Data Guard and Exadata

Compression

What Types of Compression Does Oracle Support? SecureFiles Benefits of Compression

Database Resource Manager

What Is Database Resource Manager? How Does Database Resource Manager Work? What Can Database Resource Manager Affect? Other Factors How Does Database Resource Manager Work with Exadata?

Analysis Capabilities

Analytic Functions Data Mining

Enterprise Manager Data Movement

Utilities Features

Operating Systems

Solaris Support Oracle Linux

Other Oracle Database 11g Features

Materialized Views Oracle OLAP Star Transformation Encryption

Summary

3 Exadata Software Features

Smart Scan

How Standard Queries Work How Smart Scan Queries Work Individual Tables Join Filtering Monitoring Savings from Smart Scan

Other Offloaded Processing

Fast File Creation Incremental Backup Data Mining Scoring Encryption

Exadata Hybrid Columnar Compression

What Is Exadata Hybrid Columnar Compression? How It Works Compression Options Decompression Advantages ILM and Oracle Compression

Storage Indexes

How Storage Indexes Work Storage Indexes at Work

Exadata Smart Flash Cache

What Is the Exadata Smart Flash Cache? How Can You Use the Exadata Smart Flash Cache? How Does Exadata Smart Flash Cache Determine What Is Cached? Exadata Smart Flash Cache Statistics Benefits from Exadata Smart Flash Cache

I/O Resource Manager

Benefits from I/O Resource Manager Architecture of an IORM Plan IORM at Work

Interacting with Exadata Storage Server Software

Management Software Components Command Interfaces CellCLI dcli ADRCI CellCLI Command Overview

Summary

4 Oracle Exadata Database Machine Platform Hardware Components

Latency and Balance

Processor Speeds, Memory Capacity, and Storage How Hardware Components Work Together 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

Database Server Software Components Exadata Storage Server Software Components

Exadata Storage Server Administration

Using CellCLI Exadata Storage Server OS Users and Privileges Using dcli Exadata Storage Server Setup Exadata Storage Server Security Configuration

Exadata Storage Server Monitoring

Monitoring with Metrics and Alerts Monitoring Active Requests Monitor Using the Oracle Database Monitoring with Oracle Enterprise Manager Oracle Integrated Lights Out Manager

Summary

6 High Availability and Backup Strategies

Exadata Maximum Availability Architecture (MAA)

High Availability with Oracle Data Guard Using Oracle GoldenGate with Database Machine Database Machine Patches and Upgrades Exadata Storage Server High Availability Preventing Data Corruption

Exadata Database Machine Backup and Recovery Best Practices

Backup Tools Best Practices Oracle Database Backup Strategy Database 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

SQL Aggregation and Analytics Extensions OLAP Data Mining

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

Data Models Business Intelligence Tools Security Considerations

Sizing the Platform for Data Warehousing and Justifying Purchase Summary

8 Exadata and OLTP

OLTP Workloads and Exadata Features Exadata Hardware and OLTP

General Hardware and Infrastructure Considerations Exadata Smart Flash Cache

Oracle 11g and OLTP

Classic Oracle Features Oracle and Linux Quality of Service Management

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

CPU Sizing Considerations Memory Sizing I/O Sizing System Sizing Storage Consolidation Network Consolidation

Workload Consolidation and Isolation

Services Database Server Pools Workload Management

Meeting and Exceeding SLAs

Instance Caging I/O Resource Manager (IORM) Quality of Service Management

Consolidation Design

RAC Considerations Workload-Based Consolidation Time Zone-Based Consolidation Overprovisioning Consolidation Tight SLA Provisioning Testing

Summary

10 Migrating to the Exadata Database Machine

Premigration Steps

Discovering the Current Environment Database Machine Capacity Planning and Sizing Choosing a Migration Strategy

Migration Steps for Non-Oracle Databases

Database Schema Migration Server-side Scripts Migration Data Migration and Synchronization Using Automated Tools for Migration

Migration Steps for Oracle Databases

Migrating Using Physical Methods Migrating Using Logical Methods

Summary

A Exadata Capacity and Performance Specifications

Exadata Database Machine Storage Capacity Exadata Storage Server Performance

Index

← Prev
Back
Next →

← Prev
Back
Next →