Oracle RAC & Grid Tuning with Solid-state Disk: Expert Secrets for High Performance Clustered Grid Computing

Description

Written by the world's most widely-read Oracle script developers and authors of over 50 best-selling Oracle books, Mike Ault, Robert Freeman, Don Burleson and John Garmany share their personal experience with using Solid-State RAM disk to hypercharge Oracle performance in Oracle Real Application Clusters and Oracle 10g Grid databases.

This indispensable books show you how to leverage RAM-SAN technology to create Oracle9i RAC databases with blistering speed. You will learn proven techniques for leveraging RAM disk in an Oracle RAC and Grid environment including changes to initialization parameters and the selective use of SSD in large database environments including UNDO, REDO and TEMP tablespaces on solid-state disk.

This important books shows actual TPC benchmark data and illustrates the high-bandwidth capabilities of SSD that revolutionize data retrieval engines. 

Table of Contents

Chapter 1 - Solid-State Disk with Oracle

 

This chapter introduces SSD and shows how SSD can be used within a database to improve I/O throughout and system response time.

 

Chapter 2 - SSD and Bandwidth
 

Unlike platter-based storage, solid-state disks have far higher bandwidth and this has important ramifications for Oracle databases, especially clustered environments.

 

Chapter 3 - Solid-State Disk with RAC

 

Oracle Real Application Clusters is used for failover and high availability, and SSD can be added for super-fast performance.  This chapter will show how RAC cache fusion and architecture are leveraged with SSD in a mission-critical RAC environment.

 

Chapter 4 - TPC-C Online Benchmark with Solid-State Disk

 

This is a TPC-C benchmark test of OLTP systems using SSD for various RAC components, including data files, undo, redo and TEMP tablespace.  The benchmark will also show the effect of cache fusion sizing and data buffer cache sizing when using solid-state storage.

 

Chapter 5 - TPC-H Warehouse Benchmark with Solid-State Disk

 

This chapter will show data warehouse benchmark results showing how SSD can be applied to existing data warehouse and decision support applications.  Special focus will be on the intelligent application of SSD to critical system components.

 

Chapter 6 - Oracle Tuning with Selective application of SSD

 

This chapter shows how to locate file-level I/O bottlenecks and apply SSD technology to achieve the maximum benefit.  This chapters shows techniques for identifying high I/O components and measuring the results of SSD.

 

Chapter 7 - No-disk Oracle architectures

 

This chapter describes a diskless Oracle architecture whereby all databases components are on solid-state RAM.  Topics include optimizing SGA sizes and monitoring the diskless Oracle databases.