oracle_exadata_recipes.pdf

www.it-ebooks.info

For your convenience Apress has placed some of the front

matter material after the index. Please use the Bookmarks

and Contents at a Glance links to access them.

www.it-ebooks.info

Contents at a Glance

About the Author �� xxxiii

About the Technical Reviewer �� xxxv

Acknowledgments �� xxxvii

Introduction �� xxxix

■

Part 1: Exadata Architecture

�� 1

■

Chapter 1: Exadata Hardware

�� 3

■

Chapter 2: Exadata Software

�� 33

■

Chapter 3: How Oracle Works on Exadata

�� 53

■

Part 2: Preparing for Exadata

�� 75

■

Chapter 4: Workload Qualiication

�� 77

■

Chapter 5: Sizing Exadata

�� 97

■

Chapter 6: Preparing for Exadata

�� 139

■

Part 3: Exadata Administration

�� 157

■

Chapter 7: Administration and Diagnostics Utilities

�� 159

■

Chapter 8: Backup and Recovery

�� 189

■

Chapter 9: Storage Administration

�� 239

■

Chapter 10: Network Administration

�� 297

■

Chapter 11: Patching and Upgrades

�� 331

■

Chapter 12: Security

�� 355

www.it-ebooks.info

■ Contents at a GlanCe

■

Part 4: Monitoring Exadata

�� 369

■

Chapter 13: Monitoring Exadata Storage Cells

�� 371

■

Chapter 14: Host and Database Performance Monitoring

�� 411

■

Part 5: Exadata Software

�� 445

■

Chapter 15: Smart Scan and Cell Ofload

�� 447

■

Chapter 16: Hybrid Columnar Compression

�� 477

■

Chapter 17: I/O Resource Management and Instance Caging

�� 505

■

Chapter 18: Smart Flash Cache and Smart Flash Logging

�� 529

■

Chapter 19: Storage Indexes

�� 553

■

Part 6: Post Implementation Tasks

�� 577

■

Chapter 20: Post-Installation Monitoring Tasks

�� 579

■

Chapter 21: Post-Install Database Tasks

�� 599

Index�� 633

www.it-ebooks.info

Introduction

he Oracle Exadata Database Machine is an engineered system designed to deliver extreme performance for all types

of Oracle database workloads. Starting with the Exadata V2-2 platform and continuing with the Exadata X2-2, X2-8,

X3-2, and X3-8 database machines, many companies have successfully implemented Exadata and realized these

extreme performance gains. Exadata has been a game changer with respect to database performance, driving and

enabling business transformation, increased proitability, unrivaled customer satisfaction, and improved availability

and performance service levels.

Oracle’s Exadata Database Machine is a pre-conigured engineered system comprised of hardware and software,

built to deliver extreme performance for Oracle 11gR2 database workloads. Exadata succeeds by ofering an optimally

balanced hardware infrastructure with fast components at each layer of the technology stack, as well as a unique set of

Oracle software features designed to leverage the high-performing hardware infrastructure by reducing I/O demands.

As an engineered system, the Exadata Database Machine is designed to allow customers to realize extreme

performance with zero application modiication—if you have a database capable of running on Oracle 11gR2 and

application supported with this database version, many of the features Exadata delivers are able to be capitalized

on immediately, without extensive database and systems administrator modiication. But, ultimately, Exadata

provides the platform to enable extreme performance. As an Exadata administrator, you not only need to learn

Exadata architecture and aspects of Exadata’s unique software design, but you also need to un-learn some of your

legacy Oracle infrastructure habits and thinking. Exadata not only changes the Oracle performance engineer’s way of

thinking, but it can also impose operations, administration, and organizational mindset changes.

Organizations with an existing Exadata platform are often faced with challenges or questions about how to

maximize their investment in terms of performance, management, and administration. Organizations considering

an Exadata investment need to understand not only whether Exadata will address performance, consolidation,

and IT infrastructure roadmap goals, but also how the Exadata platform will change their day-to-day operational

requirements to support Oracle on Exadata. Oracle Exadata Recipes will show you how to maintain and optimize your

Exadata environment as well as how to ensure that Exadata is the right it for your company.

Who This Book Is For

Oracle Exadata Recipes is for Oracle Database administrators, Unix/Linux administrators, storage administrators,

backup administrators, network administrators, and Oracle developers who want to quickly learn to develop efective

and proven solutions without reading through a lengthy manual scrubbing for techniques. A beginning Exadata

administrator will ind Oracle Exadata Recipes handy for learning a variety of diferent solutions for the platform,

while advanced Exadata administrators will enjoy the ease of the problem-solution approach to quickly broaden their

knowledge of the Exadata platform. Rather than burying you in architectural and design details, this book is for those

who need to get work done using efective and proven solutions (and get home in time for dinner).

The Recipe Approach

Although plenty of Oracle Exadata and Oracle 11gR2 references are available today, this book takes a diferent

approach. You’ll ind an example-based approach in which each chapter is built of sections containing solutions to

xxxix

www.it-ebooks.info

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika: