Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is it better to set the freelist to a prime number ?
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>...Received on Wed Jul 24 2002 - 09:57:47 CDT
>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/
![]() |
![]() |