Path: news.cambrium.nl!textnews.cambrium.nl!feeder3.cambriumusenet.nl!feed.tweaknews.nl!193.201.147.68.MISMATCH!feeder.news-service.com!weretis.net!feeder4.news.weretis.net!feeder1.news.weretis.net!news.solani.org!.POSTED!not-for-mail From: Mladen Gogala Newsgroups: comp.databases.oracle.server Subject: Re: ASM for single-instance 11g db server? Date: Mon, 4 Apr 2011 13:07:53 +0000 (UTC) Organization: solani.org Lines: 32 Message-ID: References: <9ab1e909-3324-41b4-a8aa-47d0516328a2@p13g2000yqh.googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Trace: solani.org 1301922473 21774 eJwNyMERwDAIA7CZ3GAM43Ap3n+EVk/xJPIqkhk0fUmGPMpC4P4/3ha0SPdb2kKX5zxqH+wHDXUQnA== (4 Apr 2011 13:07:53 GMT) X-Complaints-To: abuse@news.solani.org NNTP-Posting-Date: Mon, 4 Apr 2011 13:07:53 +0000 (UTC) User-Agent: Pan/0.133 (House of Butterflies) X-User-ID: eJwFwYkBgDAIA8CVFAhpxuGx+4/gHTzfHEYiAxfXxtR7ik2OKObGBrC9pqmnrdaVKf/o0PkBIVgQ8w== Cancel-Lock: sha1:L9tfT6LKOcXEnmlkxr9sp7kXi5c= X-NNTP-Posting-Host: eJwVyscBgAAIwMCV6OA41P1HUL+5KBtau5ia6OkN02omHj4BNHBMkxHc0WDpZ16gTZ8IYrrEcdlfJRb422tltsdjotz6BcrkGhw= Xref: news.cambrium.nl On Mon, 04 Apr 2011 01:53:01 -0700, mhoys wrote: > Hello, > > Is ASM actually recommended for a single-instance (non-RAC) Oracle 11g > installation on Linux, when the storage redundancy is managed by a SAN? > Is there a performance benefit when using ASM instead of ext3 or even > the newer ext4 filesystems? > Any good white papers out there? > > Thanks, > Matthias Mathias, ASM is usually used with RAC. That's about it. ASM is a non- standard storage method which doesn't allow things like ls, tar,cpio, cp, gzip or other Windows utilities. ASM requires a separate Oracle instance and cannot be used by anything but Oracle. ASM was invented to prevent the competition from using Oracle technology for competing products. As for ext[2,3,4] family of file systems, it's sub-standard in quality and I would stay away from it, if at all possible. JFS will provide better performance than Ext3 and is less prone to fragmentation. Ext4 is an extent based FS which was released without defragmenter. As a matter of fact, Ext4 still has no defragmenter. There is a general purpose file system defragmenter called "shake", but it's not what I expected from ext4. Long story short, stay away from ASM, unless your database is RAC, in which case it's pretty much the only reasonable choice. -- http://mgogala.byethost5.com