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: cbc latch assignment on db_cache resize

Re: cbc latch assignment on db_cache resize

From: Andrew Mobbs <andrewm_at_chiark.greenend.org.uk>
Date: 18 Jul 2002 13:18:49 +0100 (BST)
Message-ID: <9kq*kYAtp@news.chiark.greenend.org.uk>


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

Original text of this message

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