Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Times spent on latches...fast responses gratefully appreciated.
Andrew Mobbs <andrewm_at_chiark.greenend.org.uk> wrote in message news:<brb*pH8pp_at_news.chiark.greenend.org.uk>...
> Yong Huang <yong321_at_yahoo.com> wrote:
> >_kgl_latch_count = 23
>
> Is there a disadvantage to just sticking this up to 67 and leaving it
> there? (Other than the obvious support issues of undocumented
> parameters.)
I never did a good benchmark. I imagine if the number is too high, way above the number of CPUs (max 67), it would take just a little bit more time to calculate the hash value, which is used as the number of the latch. If you do a benchmark, please post the result.
Yong Huang Received on Thu Jun 06 2002 - 12:23:59 CDT