Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: type of striping

Re: type of striping

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Wed, 08 Dec 2004 11:03:26 +1100
Message-ID: <41b644cc$0$13817$afc38c87@news.optusnet.com.au>


Noons wrote:
> Howard J. Rogers wrote:
>

>>For another, ASSM is in widespread use, and that makes the number of
>>extents an issue again. Autoallocate minimises the number of extents.

>
>
>>Poorly chosen uniform sizes will cause grief with ASSM.

>
>
>
> That last sentence got me thinking, Howard.
> Trying to figure out why?

Because if you choose your uniform size poorly (ie, too small), then the number of extents a segment acquires will shoot up. And the ASSM bitmaps   get more burdensome the more extents they have to manage/deal with.

Regards
HJR Received on Tue Dec 07 2004 - 18:03:26 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US