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