Apress

Oracle Exadata Survival Guide

By David Fitzjarrell , Mary Mikell Spence

Oracle Exadata Survival Guide Cover Image

Oracle Exadata Survival Guide leads the busy DBA through the concepts and optimizations of Oracle’s Exadata performance powerhouse, providing the information necessary for successful Exadata administration.

Full Description

  • ISBN13: 978-1-4302-6010-3
  • 284 Pages
  • User Level: Intermediate to Advanced
  • Publication Date: November 16, 2013
  • Available eBook Formats: EPUB, MOBI, PDF
  • Print Book Price: $59.99
  • eBook Price: $41.99
Buy eBook Buy Print Book Add to Wishlist

Related Titles

Full Description

Oracle Exadata Survival Guide is a hands-on guide for busy Oracle database administrators who are migrating their skill sets to Oracle's Exadata database appliance. The book covers the concepts behind Exadata, and the available configurations for features such as smart scans, storage indexes, Smart Flash Cache, hybrid columnar compression, and more. You'll learn about performance metrics and execution plans, and how to optimize SQL running in Oracle's powerful, new environment. The authors also cover migration from other servers.


Oracle Exadata is fast becoming the standard for large installations such as those running data warehouse, business intelligence, and large-scale OLTP systems. Exadata is like no other platform, and is new ground even for experienced Oracle database administrators. The Oracle Exadata Survival Guide helps you navigate the ins and outs of this new platform, de-mystifying this amazing appliance and its exceptional performance. The book takes a highly practical approach, not diving too deeply into the details, but giving you just the right depth of information to quickly transfer your skills to Oracle's important new platform.
  • Helps transfer your skills to the platform of the future
  • Covers the important ground without going too deep
  • Takes a practical and hands-on approach to everyday tasks

What you’ll learn

  • Learn the components and basic architecture of an Exadata machine
  • Reduce data transfer overhead by processing queries in the storage layer
  • Examine and take action on Exadata-specific performance metrics
  • Deploy Hybrid Columnar Compression to reduce storage and I/O needs
  • Create worry-free migrations from existing databases into Exadata
  • Understand and address issues specific to ERP migrations

Who this book is for

Oracle Exadata Survival Guide is for the busy enterprise Oracle DBA who has suddenly been thrust into the Exadata arena. Readers should have a sound grasp of traditional Oracle database administration, and be prepared to learn new aspects that are specific to the Exadata appliance.

Table of Contents

Table of Contents

  1. Exadata Basics
  2. Smart Scans and Offloading
  3. Storage Indexes
  4. Smart Flash Cache
  5. Parallel Query
  6. Compression
  7. Exadata Wait Events
  8. Measuring Performance
  9. Storage Cell Monitoring
  10. Monitoring Exadata
  11. Storage Reconfiguration
  12. Migrating Databases to Exadata
  13. Migrating ERP Applications
  14. Final Thoughts
Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.

Errata

If you think that you've found an error in this book, please let us know about it. You will find any confirmed erratum below, so you can check if your concern has already been addressed.

* Required Fields

No errata are currently published