Oracle Tips   Donald K. Burleson

Oracle Managed Files (OMF)

Oracle9i has introduced some new features that up the ante for better management and performance of storage structures and have the potential to really make a difference in the database. On the better manageability front, you can make use of Oracle Managed Files (OMF) when creating your database.

For simple databases (or databases using a large RAID design), using OMF eases tablespace and redo log placement because the location of these storage structures is held in Oracle’s configuration file (SPFILE). From a storage conservation standpoint, OMF is nice because it will automatically remove any datafiles from the server when a tablespace is dropped. Note that OMF does have its drawbacks, especially for databases that require striping over many physical disks.
 

The above is an excerpt from Oracle Performance Troubleshooting by Robin Schumacher.

It's only $19.95 and you can order it and get instant access to the Oracle scripts here:

http://www.rampant-books.com/book_2003_1_perf.htm

For more details and scripts, see my new book " Oracle Tuning: The Definitive Reference", over 900 pages of BC's favorite tuning tips & scripts.  You can buy it direct from the publisher for 30%-off and get instant access to the code depot.