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

What are the sizes of, and available space on, the disks or arrays to be used with Oracle?Obviously, if there isnít enough space on the disk, you canít use it. If the size is too small to handle projected growth, then you might want to look at another asset. Oracle files can be moved, but not with that section of the database active. If you enjoy coming in before or after hours or on weekends, then by all means put your database files on an inappropriately sized disk asset.

Is this disk or array used for other non-Oracle applications? This question has a many-sided answer. From the Oracle point of view, if you have a very active non-Oracle application, it will be in contention with Oracle for the disk at every turn. If the non-Oracle application, such as a word processing or a calculation program that uses intermediate result files, results in disk fragmentation (on NT) this is bad if the datafile co-located with it has to grow and canít allocate more contiguous space. From the viewpoint of the other application, if we are talking about export files, archive log files, or growing datafiles, an asset we need to operate may be consumed, thus preventing our operation. Look carefully at the applications you will be sharing the disk assets with; talk with their administrators and make logical usage projections.

Has the disk been defragmented (for NT)? This was covered before but bears repeating. A fragmented disk is of little use to Oracle on NT; it will be a performance issue. Oracle needs contiguous disk space for its datafiles. If the disk hasnít been defragmented, have it checked by the system administrator for fragmentation, and defragment it if required.
 

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.