Contact Us  |  Ask for Pricing  |  Partners

The World's Fastest Storage®
 

superSSD > Education > Oracle Performance Center

Oracle Performance Center

Texas Memory Systems solid state disks, the World's Fastest Storage®, have improved database environments for numerous customers over the company's long history. What follows are the most popular and informative resources for Oracle DBAs considering solid state disk technology for their applications.

Recommended Tools

Write Accelerator
The Write Accelerator works on a simple premise: performance of write intensive databases is limited by two factors – latency and throughput. The Write Accelerator consists of two separate but bundled units, enabling complete support for SAME and allowing even the most demanding enterprises in the world 5-nines reliability for the solution. These two systems can be mirrored from the operating system or through Oracle's ASM.
Free Oracle Statspack Analysis
The Oracle Statspack file gives you visibility into potential I/O bottlenecks. Texas Memory Systems sponsors StatspackAnalyzer.com's free tool to upload your statspack and receive instant analysis of the results.

Identify Oracle Bottlenecks with Confio Ignite
Confio Ignite for Oracle is a performance tool used to identify and resolve performance problems in your Oracle databases and the applications that depend on them. Ignite uses industry best-practice Wait-Time methods to identify exactly which SQL and Wait-Event are causing delays in the application. Texas Memory Systems recommends Confio Ignite to help determine if your Oracle waits have an I/O cause, to identify the files creating delays, and to isolate other wait events affecting performance.

Download a free trial of Ignite for Oracle and you will be analyzing your Oracle Wait-Time in 30 minutes.

Learn more about your IO wait times with DBTop
DB Top (freeware) is from Scale-Abilities, a specialist consulting company focused on aspects of system engineering related to building very large and complex computer systems:
  
"DBTop is the logical extension to the hugely popular shareware software, Top. When run on Oracle database servers, the value offered by standard Top is severely restricted by the fact that all interesting processes are known simply as 'oracle'. By correlating the processor usage information, normally provided by Top, with internal Oracle information such as SQL and wait information, DBTop provides an essential overview of the actual activity on the server."
  

Recommended Reading

Accelerate Oracle Logs and Tablespaces Using the Writer Accelerator
Mike Ault describes in detail the vast performance increase Texas Memory Systems' plug-and-play Write Accelerator has on Oracle databases when redo logs, undo tablespaces and temporary tablespaces are placed on this device.

Don Burleson's Latest Book, Oracle RAC & Grid Tuning with Solid State Disk

Written by the world's most widely-read Oracle script developers and authors of over 50 best-selling Oracle books, Mike Ault, Robert Freeman, Don Burleson, and John Garmany share their personal experience with using SSD to hypercharge Oracle performance in Oracle Real Application Clusters and Oracle 10g Grid databases.

This book shows you how to leverage RamSan technology to create Oracle9i RAC databases with blistering speed. You will learn proven techniques for leveraging RAM disk in an Oracle RAC and Grid 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.

This book shows actual TPC benchmark data and illustrates the high-bandwidth capabilities of SSD that revolutionize data retrieval engines.

View a review of the book on the ITtoolbox blog.

Free Whitepaper: Increase Oracle Performance with Solid State Disk
This whitepaper introduces DBAs to RamSan solid state disks, discusses tools that they can use to identify I/O bottlenecks at the OS level, presents a method to identify the most frequently accessed components in an Oracle database, and discusses common ways to integrate a solid state disk into your storage architecture.


Recommended Consultants

Burleson Consulting
Texas Memory Systems has worked closely with Burleson Consulting and Mike Ault to diagnose Oracle performance issues and eliminate database bottlenecks using RamSan solid state disks.

For more information, see Mike Ault's popular powerpoint presentation, Comparison of Solid-State Disks to ATA Disks with Oracle9i (Link to Zip File). This presentation compares the performance characteristics of the solid state arrays to industry-standard SCSI and ATA arrays, including performance for inserts, index builds, and queries. In addition, it provides methods to determine if SSD is a good fit for your system.

 

The World's Fastest Storage?

What is a Solid State Disk?

Success Stories

RamSan Benefits

Solutions and Applications

Articles and Whitepapers

Press Releases

Oracle Scripts

 


Texas Memory Systems Sales - Call (713) 266-3200

Sign up for the RamSan Mailing List

Home  |  Company  |  Products  |  Support  |  Resources  |  Partners
 Contact Us  |  Legal  |   Library  |  Press  |  Success Stories  |  Privacy Policy

Copyright © 2009 Texas Memory Systems. All Rights Reserved.