|
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.
OPERA
This new storage architecture leverages Texas Memory Systems’ Flash SSD and experience in accelerating Oracle databases to provide organizations with a turnkey storage system that can be integrated with existing Oracle 11g databases. The solution is tailor-made to meet the specific needs of all Input/Output (I/O) bound Oracle databases.
The unique new advantage offered by OPERA is simple and yet extremely powerful. Thanks to the dramatically lower total cost of ownership of Flash SSD, coupled with new functions offered in Oracle 11g, performance sensitive Oracle applications can now be completely stored on Flash SSD. The performance, reliability, and cost ramifications are profound.
Video Tutorial: Oracle Performance Enhancing RamSan Architecture (OPERA) 
(Registration required) |
|
| |
|
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."
OPERA – Oracle Performance Enhancing RamSan Architecture
OPERA provides all the required components for performance and reliability at a reasonable cost. OPERA also shows that in order to truly maximize your Oracle database performance, hosting and serving the database from SSD is the most logical, and today, the most cost effective methodology to use. In this paper we delineated the limitations of 100% disk-based architectures and showed how the addition of solid state technology can dramatically improve an Oracle database system.
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.
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.
|
