Downsides to OMF?

  • From: Charles Schultz <sacrophyte@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 22 Mar 2010 13:28:02 -0500

Good day, list,

We are holding an internal discussion about the pros and cons of using
Oracle-managed files. In trying to gauge what Real World DBAs have
concluded, I am finding a lot of google hits that basically parrot the
mantra put forth by the Oracle Documentation. Basically, from what little
exposure we have had and what little I can find online, the major
disadvantage of using OMF can be boiled down to:
1. non-human-sensical names
2. Oracle related bugs (*gasp*)

Is that it? Has anyone ever run into a situation where they were using OMF
and thought, for a second, "Man, this would be so much easier if I had
manually-managed files!"?

Note that I am not concerned about ASM/RAC in this context - that adds a lot
of spice to this discussion that I'll get into later. *grin*

-- 
Charles Schultz

Other related posts: