Re: 10g ASM is junk ...

Just done the 10g New Features Course at Oracle. This gave me chance to play a little with ASM. Just to clarify one point raised in this thread - If the ASM instance crashes or is shutdown -
 NO database that is using disk groups managed by it will stay up - they all go down with it.

On the plus side it - once setup and running which is a little complicated ( but then new things often seem
that way ) - it did make the management of storage quite straight forward. I too have doubts on
how well it really compares with the like of EMC which does do some work on auto-balancing etc - time
and testing will tell.

Regards
Martin

"NetComrade" <andreyNSPAM_at_bookexchange.net> wrote in message news:40b36982.1451741704_at_localhost...
> On 25 May 2004 04:46:05 -0700, cheslyn_at_yahoo.com (Cheslyn) wrote:
>
> >ASM has other features as well other than Just data mirroring
> >
> > - Load balancing in parallel across disk drives
> > to prevent hot spots and maximize performance,
> > with rapidly changing data usage patterns.
>
> Striping usually does this. However, Oracle claims to be a bit
> 'smarter' about it. However, not sure if Oracle will try to move
> things around, as your 'hot' blocks change from night to day (e.g.
> batch vs. regular operation). IMHO, it'll take a while for an
> algorithm to replace human business knowledge and 'common sense'
>
> > - Online disk space reorganization for the incremental addition
> > or removal of storage capacity, No need to have
> > a database downtime for this
>
> Veritas can do this, but it'll take some time, and it costs extra.
> Some disk arrays allow online reorg as well.
>
> > - Reduced number of objects to manage
> > (via disk groups)
>
> That would certainly be an advantage via Veritas. But personally, I
> like control I get from Veritas over allocating data, once you
> understand all the layers of VxVM.
>
> > - ASM also overcomes file system size limitations.
> > since no file system is involved.
>
> Most file systems can now accomodate fairly large databases, but this
> could be an advantage for some.
>
> .......
> We use Oracle 8.1.7.4 on Solaris 2.7 boxes
> remove NSPAM to email
Received on Tue May 25 2004 - 13:03:13 CDT