The formula you use is based on having three cache areas, default,
keep and recycle and the old limit of 2 times the number of CPUs.
Actually you need at least one per DBWR, and one per cache area
defined. If you don't have this then you will get unequal loading of
the latches and poorer performance.
Mike
daud11_at_hotmail.com (Daud) wrote in message news:<f0bf3cc3.0207300540.3e88d45_at_posting.google.com>...
> From oracle documentation, it says that using the default value (1??)
> for db_block_lru_latches may not be good enough especially when # of
> db writers is set to more than 1. My question is will it be ok to just
> set it to the maximum which is # of cpu x 2 x 3? Any impact on the
> performance setting it to the max? The value of db_block_buffers is
> 100,000.
>
> rgds
> Daud
Received on Wed Aug 07 2002 - 08:21:47 CDT
