
Achieving Extreme Performance with Oracle Exadata
Description
Alles über E-Books | Antworten auf Fragen rund um E-Books, Kopierschutz und Dateiformate finden Sie in unserem Info- & Hilfebereich.
More details
Other editions
Additional editions

Content
- 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
System requirements
File format: ePUB
Copy protection: Adobe-DRM (Digital Rights Management)
System requirements:
- Computer (Windows; MacOS X; Linux): Install the free reader Adobe Digital Editions prior to download (see eBook Help).
- Tablet/smartphone (Android; iOS): Install the free app Adobe Digital Editions or the app PocketBook before downloading (see eBook Help).
- E-reader: Bookeen, Kobo, Pocketbook, Sony, Tolino and many more (not Kindle).
The file format ePub works well for novels and non-fiction books – i.e., „flowing” text without complex layout. On an e-reader or smartphone, line and page breaks automatically adjust to fit the small displays.
This eBook uses Adobe-DRM, a „hard” copy protection. If the necessary requirements are not met, unfortunately you will not be able to open the eBook. You will therefore need to prepare your reading hardware before downloading.
Please note: We strongly recommend that you authorise using your personal Adobe ID after installation of any reading software.
For more information, see our ebook Help page.