Path: news.easynews.com!easynews!newshosting.com!news-xfer2.atl.newshosting.com!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!intgwpad.nntp.telstra.net!news.telstra.net!newsfeeds.bigpond.com!not-for-mail
Message-ID: <3D521EBF.5C1DDFE6@oracle.com>
From: Richard Foote <Richard.Foote@oracle.com>
Organization: Oracle Corporation
X-Mailer: Mozilla 4.75 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: Generic "Can I extend?" check
References: <3D518D84.4A77@yahoo.com>
Content-Type: multipart/mixed;
 boundary="------------CCDEEF1794BC9F8E178D99EF"
Lines: 75
Date: Thu, 08 Aug 2002 17:33:19 +1000
NNTP-Posting-Host: 144.139.227.235
X-Trace: newsfeeds.bigpond.com 1028791896 144.139.227.235 (Thu, 08 Aug 2002 17:31:36 EST)
NNTP-Posting-Date: Thu, 08 Aug 2002 17:31:36 EST
Xref: easynews comp.databases.oracle.server:157237
X-Received-Date: Thu, 08 Aug 2002 00:36:07 MST (news.easynews.com)
--------------CCDEEF1794BC9F8E178D99EF
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

Hi Connor,

You are a clever boy !!

Quick question, where did you get these figures, are they documented
somewhere or was it play and tell ?

Cheers

Richard

Connor McDonald wrote:
> 
> I've been asked to write a generic routine to determine if a segment can
> extend.  Easy enough except for auto-alloc lmt's where 'next_extent' is
> null (ie indeterminate) in xxx_SEGMENTS.
> 
> So here is my current compromise (in pseudo-code)
> 
> where nvl(next_extent,
>   case
>     when initial_extent < 1m then
>       case when extents < 16 then next = 64k,
>            when extents < 80 then next = 1m,
>            when extents < 200 then next = 8m,
>            else next = 64m
>     when initial_extent >= 1m then
>       case when extents < 64 then next = 1m,
>            when extents < 184 then next = 8m,
>            else next = 64m )
>   > largest_free_space_chunk_in_tablespace
> 
> The rough translation being:
> - auto-alloc extents are 16x64k, then 64x1m, then 120x8m, then 64m, when
> the initial_extent is less than 1m
> - auto-alloc extents are 64x1m, then 120x8m, then 64m, when the
> initial_extent is equal/more than 1m
> 
> In the spirit of "open source", I'm throwing this out the community
> asking for counter-examples which break the above formula.
> 
> Thanks
> Connor
> 
> --
> ==============================
> Connor McDonald
> 
> http://www.oracledba.co.uk
> 
> "Some days you're the pigeon, some days you're the statue..."
--------------CCDEEF1794BC9F8E178D99EF
Content-Type: text/x-vcard; charset=UTF-8;
 name="Richard.Foote.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Richard Foote
Content-Disposition: attachment;
 filename="Richard.Foote.vcf"

begin:vcard 
n:;Richard
x-mozilla-html:FALSE
adr:;;;;;;
version:2.1
email;internet:Richard.Foote@oracle.com
fn:Richard Foote
end:vcard

--------------CCDEEF1794BC9F8E178D99EF--