Re: latch contention

From: giorgio.sorbara _at_ sorcius.com <_at_>
Date: Wed, 27 Jun 2001 10:45:12 +0200
Message-ID: <9hc6f7$7iq$1@news.mclink.it>

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.

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.

HTH,
G

"Alexey Ogol" <lesha_at_crgu.com> wrote in message news:9hc1k3$247n$1_at_pandora.alkar.net...
> Hi,
>
> I run UTLBSTAT/UTLESTAT scripts, and I realize that there's a 'cache
buffer
> chains' latch contention in the database. How can I eliminate this
problem?
>
> Thanks in advance,
> Alexey
>
>
Received on Wed Jun 27 2001 - 03:45:12 CDT