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: Tue, 23 Jul 2002 08:44:39 +0100
Message-ID: <1027410622.10650.0.nnrp-08.9e984b29@news.demon.co.uk>

I think it is purely down to the choice
of algorithm. The hash function Oracle
uses for hash partitions is clearly
designed as a 2^N algorithm for mechanical reasons. But I have a memory that the best randomisers always used prime numbers
for the hash target.

--
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

Yong Huang wrote in message
<07b6be7c6105b142172a9b70371d2d92.99975_at_mygate.mailgate.org>...

>"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message
>news:1026200922.18484.1.nnrp-13.9e984b29_at_news.demon.co.uk
>
>>
>> When a process requests a free list,
>> it uses some sort of 'hashing' function
>> to select which free list, based on the
>> process id. Using a prime number
>> with such mechanisms usually reduces
>> the number of collisions that occur if
>> the input is randomly distributed.
>
>Jonathan, I think you meant non-randomly, or not sufficiently randomly.
>Otherwise why does the prime number matter? But I could be wrong.
>
>Yong Huang
>
>
>--
>Posted via Mailgate.ORG Server - http://www.Mailgate.ORG
Received on Tue Jul 23 2002 - 02:44:39 CDT

Original text of this message

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