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 Disk Layout

Is the disk a raw device (for UNIX)? If the disk is a raw device, this restricts your capability for file naming. Be sure you maintain an accurate log of tablespace mapping to raw devices. Map tablespace and other asset locations ahead of time. Remember, an entire raw partition must be used per Oracle datafile; it cannot be subpartitioned without redoing the entire raw setup. If you must use raw, plan it!

What is the speed of the disk? By speed of disk we are referring to the access and seek times. The disk speed will drive disk throughput. Another item to consider when looking at disk speed is whether or not the disk is on a single or shared controller. Is the DSSI chained? All of these questions affect device throughput. Generally, datafiles and indexes should go on the fastest drives; if you must choose one or the other, put indexes on the fastest. Rollback segments and redo logs can go on the slowest drives as can archive logs and exports.

Is the disk a RAM or an optical disk? Ultimately, the RAM and optical usage ties back to disk speed. A RAM drive should be used for indexes due to its high speed. It is probably not a good candidate for datafiles due to the RAM drive’s current size limitations; this may change in the future. An optical drive, due to its relative slowness, is excellent for archives and exports, but probably shouldn’t be used for other Oracle files. A possible exception might be large image files (BLOBs) or large document files. Usually, unless you have a rewritable CD system, the tablespaces placed on a CD-ROM will be read-only. With the storage capacities of most optical drives, they make excellent resources for archive logs and exports. They can conceivably provide a single point of access for all required recovery files, even backups. This solves the biggest recovery bottleneck: restoration of required files from tape.
 

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.