Re: What to keep in ASM?

Hi Don,    

  It is precisely for this reason that I asked for an explanation as to why you think that the load balancing of ASM is a big win.   Perhaps you should read Gopal's 10G RAC handbook    

  Regards
  Fairlie

K Gopalakrishnan <kaygopal_at_gmail.com> wrote:   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 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 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





          Fairlie Rego
Senior Oracle Consultant
  http://www.linkedin.com/in/fairlierego
  
  http://el-caro.blogspot.com/
  M: +61 402 792 405
   






 
---------------------------------
Never miss an email again!
Yahoo! Toolbar alerts you the instant new Mail arrives. Check it out.
--
http://www.freelists.org/webpage/oracle-l