Re: latch contention

From: Alexey Ogol <lesha_at_crgu.com>
Date: Wed, 27 Jun 2001 12:12:34 +0300
Message-ID: <9hc80g$2m36$1@pandora.alkar.net>

> from metalink...
>
> Cache buffers chains latch:
> This latch is needed when user processes try to scan
> the SGA for database cache buffers.
> This latch is related to DB_BLOCK_HASH_BUCKETS (undocumented in
> Oracle7) which is related to db_block_buffers. It can be tuned by
> adjusting DB_BLOCK_BUFFERS.

I run 8.1.7 EE, and it seems that there's no DB_BLOCK_HASH_BUCKETS parameter.
Adjusting db_block_buffers doesn't help too... What else can I do?

> Cache buffers LRU chain latch:
> This latch is needed when user processes try to scan
> the LRU (least recently used) chain containing all the dirty blocks
> in the buffer cache.
> Cache buffers LRU chain latch:
> Increasing the parameters DB_BLOCK_BUFFERS and DB_BLOCK_WRITE_BATCH
> (undocumented in Oracle7) will reduce waits on this kind of latches.
Received on Wed Jun 27 2001 - 04:12:34 CDT