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: Is it better to set the freelist to a prime number ?

Re: Is it better to set the freelist to a prime number ?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 24 Jul 2002 15:57:47 +0100
Message-ID: <1027522604.24440.0.nnrp-01.9e984b29@news.demon.co.uk>

Thanks for the reference, which I've followed up. Suddenly it's all clear.

It makes no difference whether the value is prime or not. The significance appears I think when you use multiple free lists AND multiple freelist groups in a single instance.

In this case, the number of freelists and the number of freelist groups must be relatively prime (co-prime ?) or you don't make use of all the freelists in all the freelist blocks.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminars
 UK  Sept
 Australia August
 Malaysia September
 USA x 2  November

http://www.jlcomp.demon.co.uk/seminar.html

Andrew Mobbs wrote in message <9uo*Yp3tp_at_news.chiark.greenend.org.uk>...

>Connor McDonald <connor_mcdonald_at_yahoo.com> wrote:
>>
>>Do we (anyone?) have any insider info on the hash algorithm used for
>>freelist mapping? Is it plain ol' modulo - in which case, the use of
>>prime number would be suitable, but there's also endless (non-modulo)
>>hashing algoriths out there that would not have such a requirement
>
>Metalink Doc Id 1029850.6
>
>Basically, yes, it's just PID mod number of freelists (or groups).
>
>--
>Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/
Received on Wed Jul 24 2002 - 09:57:47 CDT

Original text of this message

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