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 ?
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>...Received on Tue Jul 09 2002 - 02:49:12 CDT
>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
![]() |
![]() |