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




Donald K. Burleson

Oracle Tips  

Oracle Redundant Arrays of Inexpensive Disks (RAID)

For the money, I would suggest RAID0/1 or RAID1/0, that is, striped and mirrored. It provides nearly all of the dependability of RAID5 and gives much better write performance. You will usually take at least a 20 percent write performance hit using RAID5. For read-only applications RAID5 is a good choice, but in high-transaction/high-performance environments the write penalties may be too high. Table 1.1 shows how Oracle suggests RAID should be used with Oracle database files.

Oracle RAID Recommendations

Oracle is a broad topic; topics related to Oracle and Oracle data storage are even broader. This section will touch on several new technologies such as optical disk, RAM disk, and tape systems that should be utilized with Oracle systems whenever possible. Proper use of optical technology can result in significant savings when large volumes of static data are in use in the database (read-only). RAM drives can speed access to index and small table data severalfold. High-speed tapes can make backup and recovery go quickly and easily. Let’s examine these areas in more detail.

Oracle Optical Disk Systems 

WORM (write-once, read-many) or MWMR (multiple-write, multiple-read) optical disks can be used to great advantage in an Oracle system. Their main use will be in storage of export and archive log files. Their relative immunity to crashes and their long shelf life provide an ideal solution to the storage of the immense amount of data that proper use of archive logging and exports produce. As access speeds improve, these devices will be worth considering for these applications with respect to Oracle. They have also shown great benefits in read-only tablespaces and in transportable tablespace sets, a new feature of Oracle8i and 9i.

This is an excerpt by Mike Ault’s book “Oracle Administration & Management”.  If you want more current Oracle tips by Mike Ault, check out his new book “Mike Ault’s Oracle Internals Monitoring & Tuning Scripts” or Ault’s Oracle Scripts Download.




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.