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

Donald Burleson, Mike Ault

  • 出版商: Rampant Tech Press
  • 出版日期: 2005-02-01
  • 售價: $593
  • 貴賓價: 9.5$563
  • 語言: 英文
  • 頁數: 240
  • 裝訂: Paperback
  • ISBN: 0974448656
  • ISBN-13: 9780974448657
  • 相關分類: Oracle
  • 無法訂購

買這商品的人也買了...

商品描述

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