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, 9 Jul 2002 08:49:12 +0100
Message-ID: <1026200922.18484.1.nnrp-13.9e984b29@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.

I think it may have been Anjo Kolk who
first came out with this suggestion.

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

Next Seminars
        UK            July / Sept
        Australia      July / August
        Malaysia        September
        USA (MI)        November
http://www.jlcomp.demon.co.uk/seminar.html

yewpc wrote in message <3d2a7f6e$1_at_usenetgateway.com>...

>Hi everyone,
>
>I was told before that freelist should be set to less than max
>concurrent users and better use a prime number.
>
>Does anyone know why it is better to use a prime number ?
>
>Thank you
>
>Regards, ypc
>
>
>
>--
>Posted via dBforums
>http://dbforums.com
Received on Tue Jul 09 2002 - 02:49:12 CDT

Original text of this message

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