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.

* 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. Donald Burleson's books   Donald Burleson articles   Donald Burleson comments   Don Burleson blog   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

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

Index Topics: