book

Oracle Exadata Survival Guide

by David Fitzjarrell, Mary Mikell Spence

November 2013

Intermediate to advanced

284 pages

8h 40m

English

Apress

Read now

Unlock full access

What Is Exadata?Available ConfigurationsStorageSmart Flash CacheEven More StorageThings to Know
Smart ScansPlans and MetricsSmart Scan OptimizationsColumn ProjectionPredicate FilteringBasic JoinsOffloading FunctionsVirtual ColumnsThings to Know

An Index That Isn’tDon’t Look HereI Used ItOr Maybe I Didn’tExecution Plan Doesn’t KnowThe More, the MerrierNULLsNeeding to “Rebuild”Things to Know
Flash MeHow It WorksLogging We Will GoIt’s a DiskMonitoringWhat a PerformerThings to Know
Getting into the QueueOld SchoolThe New MethodControl IssuesNecessary SettingsMy Friend AutoDo It in MemoryThings to Know
How Can I Compress TheeThe Nuts and Bolts of HCCPerformanceRatios—What to ExpectThings to Know
Available Nowhere ElseTriggering EventsUser I/O EventsSystem I/O EventsIdle Class/Other ClassThings to Know
Measure Twice, Cut OnceSmart Scans, AgainPerformance Counters and MetricsThings to Know
Talking to the Storage CellsWhat’s in a Name?Monitoring BasicsThings to Know
The Database LayerAre We There Yet?The Storage Cells
I Wish We Had More…Redistributing the WealthThings to Know
Getting PhysicalThat’s LogicalThings to Know
Cloning the Oracle HomeThe SCAN ListenerCreating a DatabaseSetting Up the ListenerData MigrationEnvironment ConfigurationSetting the Environment“My Oracle Support” NotesThings to Know
You’ve Come Far, PilgrimTo DMA or Not to DMAWhat You Don’t Know, You Can Look UpThings to Know

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

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.