Oracle Exadata Survival Guide

by David Fitzjarrell, Mary Spence

Overview

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

Product Details

ISBN-13:	9781430260110
Publisher:	Apress
Publication date:	11/29/2013
Sold by:	Barnes & Noble
Format:	eBook
Pages:	284
File size:	7 MB

About the Author

David Fitzjarrell is a Senior Oracle Database Administrator living in the Denver/Boulder area of Colorado. He has over 23 years experience in various industries, and is currently working with Exadata in a large-scale, OLTP and ERP retail environment. He started with Oracle Version 6.0, and has worked with almost every release since, concentrating on the areas of physical administration and performance tuning. David is the Social Media Director for the Rocky Mountain Oracle Users Group, contributes monthly articles for databasejournal.com, participates in various Oracle forums and newsgroups and writes an Oracle-centric blog at http://dfitzjarrell.wordpress.com.

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