Oracle Solid State Disk Tuning: High Performance Oracle Tuning with RAM Disk

Description

Written by the world's most widely-read Oracle script developers and authors of over 50 best-selling Oracle books, Mike Ault and Don Burleson share their personal experience with using Solid-State RAM disk to hypercharge Oracle performance.

As SGA data buffers are replaced by high-speed Sold-state disks the rules for Oracle tuning change radically and this indispensable books show you how to leverage RAM-SAN technology to create Oracle databases with blistering speed. You will learn proven techniques for leveraging RAM disk in an Oracle 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.

 

Table of Contents

Chapter 1 - Judging Solid-State Disk with Oracle

Introduction
Introduction to Oracle data caching
SSD as an Oracle Tuning Tool
RAM access speed with Oracle Databases

     The History of Oracle RAM data buffering
     Allocating Oracle Objects into Multiple RAM data Buffers
     Improving I/O speed is not a silver bullet
     The problem of duplicitous RAM caches
     Why is Oracle logical I/O so slow?
     Finding the Baselines
     A Review of existing SSD Research findings

          James Morle
          Dr. Paul Dorsey
          Woody Hutsell

SSD Conclusions
References
SSD Benchmark Hypothesis

     Specific architectures
     Predictions
Conclusions

 

Chapter 2 - Choosing a Benchmark

 

TPC Benchmark H Overview

     Benchmark Hardware Architecture
     Benchmark Methodology

     Conclusion

 

Chapter 3 - Setup for Testing

 

The Real Work
Server Configuration

     Disk Configurations
     Network Configurations
     Database Configuration

Data Loading
Index Builds
Analyze Runs
Conclusion

 

Chapter 4 - Testing SSD Verses ATA Performance

Introduction
Query Processing

     SSD Results
     Summary of Findings
     SCSI and ATA Runs

          ATA Configurations

Comparing the Different Scenarios

     SSD Scenario Comparisons.
     SCSI/ATA Scenario Comparisons

          Standard SCSI/ATA Runs
          Run 3 with Temporary and Undo on SSD
          Run 4 with DATA on SSD
          Run 5 with Data on SSD and Reduced Memory

Conclusion

 

Chapter 5 - Is SSD Right for Your Database?

 

Introduction
Analyzing What to Put On SSD

     Analysis Tools

          Custom Scripts
          Using the STATSPACK Report to Analyze I/O Performance

          Installing STATSPACK
          Reviewing the STATSPACK Report for SSD

     Example STATSPACK Results from the SSD Runs
     When a System Won’t Benefit From Moving to SSD

Conclusion

 

Appendix A - Example Scripts

 

Appendix A

     Index Creation Script
     SSD Queries Script
     SCSI/ATA Queries Script

 

Appendix B - Example PAR and Data Listings

 

Appendix B

     Customer Table
     Lineitem Table
     Orders Table
     Part Table
     Partsupp Table
     Region Table
     Supplier Table
     Nation Table

 

Appendix C - Data Loading and Index Build Statistics

 

Appendix C

     Load Statistics for the Solid State Array
     Load Data for the ATA Array
     Index Creation Data

 

Appendix D - STATSPACK Report Listings

 

Appendix D

     SSD Query Run Results
     SCSI/ATA Query Results

 

Appendix E - STATSPACK Report Listings

 

Appendix E

     Statspack for ATA Query Run with No SSD Usage
     StatsPack Report for ATA With Temp and Undo on SSD
     Statspack for ATA with Data On SSD
     Statspack for 50% Memory Reduction with Data on SSD
     Example SSD Statspack Report
     Example Statspack For “False Positive”
     Statspack Report for Good Candidate for SSD

 

Index

About Donald Burleson

About Mike Ault

About Mike Reed