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