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


 

HTML Text

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.

 

 ”call

  
 

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.