Re: What to keep in ASM?

From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Mon, 26 Feb 2007 19:42:25 -0800
Message-ID: <3b0f44a10702261942s3efc8d81kb7a34881fc767d2a@mail.gmail.com>

Don,

It is slightly incorrect. ASM does not work at block level. It works at extent level or allocation unit level (1MB most cases) and hotblocks exist in ASM too. You may have to tweak the block level parameters to avoid hotblocks.. You may want to use X$KSLHOT to nail down them.

On 2/26/07, Don Seiler <don_at_seiler.us> wrote:
> My understanding is that ASM will also shift data around to avoid the
> "hot block" scenario, avoiding I/O contention. It wasn't explicitly
> stated in the passage I pasted, hopefully my understanding is correct.
>
> Don.
>
> On 2/26/07, Alexander Fatkulin <afatkulin_at_gmail.com> wrote:
> > > Am I giving this feature too much credit?
> >
> > ASM spread extents in proportion to the disk size regardless of the
> > speed and workload characteristics of the underlying hardware (at
> > least I never saw the opposite).
> >

-- 
Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/

Author: Oracle Database 10g RAC Handbook, Oracle Press 2006
http://www.amazon.com/gp/product/007146509X/
--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 26 2007 - 21:42:25 CST