Re: 10g ASM - does it work practically?

On Mon, 22 Nov 2004 10:27:35 +0100, Cookie Monster wrote (in article <30dpnkF2un3voU1_at_uni-berlin.de>):

> Hi,
>
> I read the marketing hype and checked the documentation, but I want to know
> does ASM (Automatic storage management) in 10g really work? I'm looking at
> upgrading from 9i to 10g and one feature that does stand out is ASM, it
> sounds nice, but practically I want to know if anyone has used it and does
> it give you the benefits you expected? Easy management of tablespaces and
> improved disk access performance (I'm not keen on raw devices you see). Or
> is it like - well I never noticed the difference?.
>
> Thanks for any feedback,
> Steve.
>
>

Hi Steve,

I can say it does work. Used it for a project on Solaris and it does what the docs say. Just create the database using OMF + ASM and dont worry about file placement striping or whatever. Make sure you have enough disks and decide how you want what level of redendancy.

Be sure to prevent your archive destination from getting full since the ASM instance will crash. I did put most files on ASM, except for the spfile because that would als for a pfile to point to the fully qualified spfile on ASM and that's not friendly.

With kind regards / met vriendelijke groeten, Ronald

http://ronr.nl/unix-dba
http://homepage.mac.com/ik_zelf/oracle Received on Mon Nov 22 2004 - 05:28:56 CST