From: Robert Freeman <>
Date: Thu, 16 Oct 2008 08:40:12 -0700 (PDT)
Message-ID: <>

I am hard pressed to find enough good reasons to use ASM over cooked on a protected file system (ie: RAID) in a non-RAC environment most of the time.... However, given what I think the future of ASM might become, this might change at some point in time. Ya never know... ;-)


 Robert G. Freeman
Oracle Database 11g New Features (Oracle Press) Portable DBA: Oracle (Oracle Press)
Oracle Database 10g New Features (Oracle Press) Oracle9i RMAN Backup and Recovery (Oracle Press) Oracle9i New Feature
Blog: (Oracle Press) The LDS Church is looking for DBA's. You must be LDS to apply (please don't write to me and tell me I'm breaking the law. A church can choose to hire members of it's own faith. Look it up if you don't believe me).

  • Original Message ---- From: Niall Litchfield <> To: Cc:;; Greg Rahn <>; ORACLE-L <> Sent: Thursday, October 16, 2008 9:25:21 AM Subject: Re: ASM

Reasons for ASM that I can see. I agree with most of your negatives :).

  • Ease of file management - which is mostly OMF rather than ASM per se. (that's a disagreement!)
  • Ease of disk management - having the ability to migrate a db from one set of physical disks to another witout downtime is very, very cool.
  • On windows avoiding the whole drive letter management thing. Now against that, and in addition to Jared's points. I'd ask why consider a storage solution that only works for Oracle files (and even then not all Oracle files. I keep other files on my servers you know. Including stuff you'd expect to be there like alert.logs, cron scripts and so on.

On Wed, Oct 15, 2008 at 8:48 PM, Jared Still <> wrote:

On Wed, Oct 15, 2008 at 6:21 AM, Dan Norris <> wrote:

If you would, please share with us your reasons to avoid ASM. Based on your response, I'm guessing that the reasons might include "because that's the way I've always done it".

Personally, I don't use it as it adds more complexity to our environment.

We (by which I really me 'I') don't need to add any more complexity.

  • Additional instance for ASM
  • file management is simpler
  • storage admins have easy direct access to see what's on disk.

I'm sure there are some rebuttals to this.

Let's hear 'em!

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Niall Litchfield
Oracle DBA

Received on Thu Oct 16 2008 - 10:40:12 CDT

Original text of this message