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

Description

This guide to leveraging RAM-SAN technology shows Oracle DBAs how to create fast Oracle9i RAC databases. Techniques for leveraging RAM disk in an Oracle RAC and Grid environment are demonstrated including changes to initialization parameters and the selective use of SSD in large database environments (UNDO, REDO, and TEMP tablespaces on solid-state disk).

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.