Re: What to keep in ASM?
- From: "K Gopalakrishnan" <kaygopal@xxxxxxxxx>
- To: don@xxxxxxxxx
- Date: Mon, 26 Feb 2007 19:42:25 -0800
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@xxxxxxxxx> 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@xxxxxxxxx> 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/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
