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 ?
"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.ORGReceived on Mon Jul 22 2002 - 23:03:00 CDT