Call (800) 766-1884 for Oracle support & training
Free Oracle Tips

Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance

Free Oracle Tips



BC Oracle tuning

Oracle training

Oracle support

Remote Oracle



  Oracle Tips by Burleson

SSD Conclusions

Research indicates that SSD can be very valuable to Oracle databases, with the total benefit depending on the type of processing characteristics.

Use SSD for high-impact files – Oracle redo log files, undo segment, and temporary tablespace file will greatly benefit from SSD.

SSD has impressive speed improvements - (Dorsey, 2004) reported a 67% gain (.67x) in data access speed with SSD.  (Morle, 2002) noted a reported a 25% (.25x) increase in system speed with SSD

SSD may shift the Oracle bottleneck to CPU – SSD should only be attempted when CPU consumption (as measured by a STATSPACK top-5 wait event report) is less than 50% of the consumption.  Using SSD will shift the bottleneck from I/O to CPU, and the server may require more CPU’s to improve dispatching, or faster CPU’s (e.g. Itanium2 processors).

Read-intensive system benefit most from SSD – Write-intensive systems, especially those with high buffer invalidations, may only see a marginal speed improvement.

SSD will speed-up access on super-large disks – The 114 gigabyte disk often experiences disk enqueues as competing tasks wait their turn at the read-write heads.  SSD will surely improve throughput for these types of database disks.

The above book excerpt is from:

Oracle Solid State Disk Tuning

High Performance Oracle tuning with RAM disk

ISBN 0-9744486-5-6  

Donald K. Burleson & Mike Ault


Oracle performance tuning software 

Oracle performance tuning book


Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel
Oracle training & performance tuning books



Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. 

Hit Counter