Oracle Consulting Oracle Training Oracle Support Development
Home
Catalog
Oracle Books
SQL Server Books
IT Books
Job Interview Books
eBooks
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
image
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
 Phone
 800-766-1884
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books
image
image

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle

STATSPACK Viewer

Privacy Policy

  

 

ISBN
0-9744486-5-6
ISBN 13
978-0974448657
Library of Congress Number: 2004113187
200 pages
Perfect bind - 9x7
PD 505
Shelving: Database/Oracle Oracle In-Focus Series # 7

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

Donald K. Burleson & Mike Ault   

Retail Price $16.95 /  £10.95 

Order now and get immediate access to the code depot! Only $9.95
(30% off)
     
Key Features About the Authors Table of Contents
Index Reader Comments Errata
     
Get the Oracle Tuning Library
Save $100 - All four books for only $118.95 
Oracle Tuning: The Definitive Reference 3rd Edition $69.95
Advanced Oracle SQL Tuning: The Definitive Reference $59.95
Oracle Performance Troubleshooting 2nd Ed $34.95
Oracle Tuning Powerscripts $37.95

 

 

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.

 

 
Key Features

* Learn the type of databases that benefit the most from solid-state technology.

* See real-world benefits of replacing old-fashioned disk with high-speed RAM-SAN.

* Understand how SSD causes huge performance improvements for I/O intensive Oracle databases.

* Use proven techniques for the selective application of RAM disk.

* Learn who to tune an entire database by speeding-up the I/O sub-system.

* Get a code depot of analysis script to see if solid-state disk is right for your Oracle database.

 

About the Authors:


Donald Burleson

Donald K. Burleson is one of the world’s top Oracle Database experts with more than 25 years of full-time DBA experience.  He specializes in creating database architectures for very large online databases and he has worked with some of the world’s most powerful and complex systems.  

A former Adjunct Professor, Don Burleson has written more than 30 books, published more than 100 articles in National Magazines, and serves as Editor-in-Chief of Rampant TechPress. Don is a popular lecturer and teacher and is a frequent speaker at Oracle OpenWorld and other international database conferences.

 

Free Oracle Tips

HTML Text

Mike Ault

Mike Ault has five Oracle Masters Certificates.  Ault was the first popular Oracle author with his book "Oracle7 Administration and Management" and he also wrote several of the "Exam Cram" books.

 


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 duplicate 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

Download the Oracle SSD benchmark: 

http://www.rampant-books.com/tpc_ssd_oracle_benchmark.doc


Index Topics:

A
archivelogging
Automatic Memory Management
Automatic Workload Repository
C
chkconfig
clustering_factor
D
Data Buffer Hit Ratio
data caching
db_k_cache_size
db_k_cache_size
db_k_cache_size
db_k_cache_size
db_k_cache_size
db_cache_size
db_file_sequential_reads
db_keep_cache_size
db_recycle_cache_size
dba_hist_db_cache_advice
dba_hist_filestatxs
dba_tables.avg_row_len
dbca
dbgen
dbms_stats
df_file_scattered_reads
dss_admin
dss_data
dss_index
E
env
I
iostat
 
J
Journal File System
M
Moore’s Law
N
noarchivelog
noarchiving
nohup
nologging
O
optimizer_index_caching
optimizer_index_cost_adj
optimizer_mode
Oracle Logical I/O
P
pga_max_allocation
Physical Disk I/O
Q
qgen
R
RAM cache
Redo log files
S
sdb
show parameter
SQL*Loader
STATSPACK

 
T
Temporary tablespace blocks
TPC Benchmark™ H
TPC-C benchmarks
TPCH benchmark
Transaction Processing Performance Council
U
Undo segments
V
v$datafile
v$db_cache_advice
v$filestat
v$sesstat
v$sysstat
v$tempfile
v$tempstat
v$waitstat
vmstat

 

Hit Counter

   

 Copyright © 1996 -2016 by Burleson. All rights reserved.


Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks