Oracle Database Tips by Donald Burleson
Analysis Tools
BC's
most recent Oracle analysis software is
Ion for Oracle , a
truly proactive Oracle analysis software that gets right to the
heart of any Oracle performance problem. Ion for Oracle uses
STATSPACK or AWR to analyze for hidden trends and signatures, making
it a smart choice for expert Oracle analysis.
Click "Play" to take the tour or visitwww.Ion-DBA.com
In many situations, the operating system level analysis may be
inconclusive due to the combining of physical disks into large, RAID
combined logical disks. In this case, the I/O to the individual
datafiles from the Oracle perspective must get a good look.
Custom scripts
Oracle Enterprise Manager
Third-party tools
AWRPRT reports
The use of custom scripts gives the analyst control over the
selection and display of specific statistics of concern. Oracle
Enterprise Manager (OEM) provides a plethora of data but may not be
available at all sites. Third-party tools also provide a wealth of
data but are expensive and may not be installed at all client
locations. STATSPACK reports are available at all sites, provide a
wealth of statistics and allow a focused look at specific time
intervals.
The above book excerpt is from:
Oracle RAC
& Grid Tuning with Solid State Disk
ISBN:
0-9761573-5-7 Mike Ault, Donald K. Burleson
http://www.rampant-books.com/book_2005_2_rac_ssd_tuning.htm
Market Survey of SSD vendors for
Oracle: There are many vendors who offer rack-mount solid-state disk that
work with Oracle databases, and the competitive market ensures that
product offerings will continuously improve while prices fall.
SearchStorage notes that SSD is will soon replace platter disks and that
hundreds of SSD vendors may enter the market:
"The number of vendors in this category could rise to several
hundred in the next 3 years as enterprise users become more familiar
with the benefits of this type of storage."
As of January 2015, many of the major hardware vendors (including Sun and
EMC) are replacing slow disks with RAM-based disks, and
Sun announced that all
of their large servers will offer SSD.
Here are the major SSD vendors for Oracle databases
(vendors are listed alphabetically):
2008 rack mount SSD Performance Statistics
SearchStorage has done a comprehensive survey of rack mount SSD
vendors, and lists these SSD rack mount vendors, with this showing the
fastest rack-mount SSD devices:
manufacturer
model
technology
interface
performance metrics and notes
IBM
RamSan-400
RAM SSD
Fibre
Channel
3,000MB/s random
sustained external throughput, 400,000 random IOPS
Violin Memory
Violin 1010
RAM SSD
PCIe
1,400MB/s read,
1,00MB/s write with ×4 PCIe, 3 microseconds latency
Solid Access Technologies
USSD 200FC
RAM SSD
Fibre Channel
391MB/s random
sustained read or write per port (full duplex is 719MB/s), with
8 x 4Gbps FC ports aggregated throughput is approx 2,000MB/s,
320,000 IOPS
Curtis
HyperXCLR R1000
RAM SSD
Fibre Channel
197MB/s sustained
R/W transfer rate, 35,000 IOPS
Choosing the right SSD for Oracle When evaluating SSD for Oracle databases you need
to consider performance (throughput and response time), reliability (Mean Time Between failures) and
TCO (total cost of ownership). Most SSD vendors will provide a
test RAM disk array for benchmark testing so that you can choose the
vendor who offers the best price/performance ratio.
Burleson Consulting does not partner with any SSD vendors and we
provide independent advice in this constantly-changing market. BC
was one of the earliest adopters of SSD for Oracle and we have been
deploying SSD on Oracle database since 2005 and we have experienced SSD
experts to help any Oracle shop evaluate whether S SD
is right for your application. BC experts can also help you choose
the SSD that is best for your database. Just call 800-766-1884 or e-mail.:
for
SSD support details.
DRAM SSD
vs. Flash SSD
With all
the talk about the Oracle “flash cache”, it is important to note that there
are two types of SSD, and only DRAM SSD is suitable for Oracle database
storage. The flash type SSD suffers from serious shortcomings, namely
a degradation of access speed over time. At first, Flash SSD is 5
times faster than a platter disk, but after some usage the average read time
becomes far slower than a hard drive. For Oracle, only rack-mounted
DRAM SSD is acceptable for good performance:
Avg. Read speed
Avg. write speed
Platter disk
10.0 ms.
7.0 ms.
DRAM SSD
0.4 ms.
0.4 ms.
Flash SSD
1.7 ms.
94.5 ms.
and include the URL for the page.
