Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: cbc latch assignment on db_cache resize
Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk> wrote:
>
>So I was going to test the theory that the
>number of cbc latches is determined by
>largest number of buffers you could demand
>given the smallest block size with a defined
>cache.
That's interesting, thanks. I haven't touched differing block sizes yet.
>BTW - the number of latches in 9.2 seems
>to revolve around significant powers to 2.
>I think you are thinking of the number of
>hash buckets when you say 'prime number
>close to twice the buffers'.
Er... yes, you're quite right, my notes agree that I meant buckets.
-- Andrew Mobbs - http://www.chiark.greenend.org.uk/~andrewm/Received on Thu Jul 18 2002 - 07:18:49 CDT