Message-Id: <10589.114524@fatcity.com> From: "Diego Cutrone" Date: Mon, 14 Aug 2000 16:02:19 -0300 Subject: Some Latch Questions This is a multi-part message in MIME format. ------=_NextPart_000_0747_01C00609.063B5D40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, Forgive my poor english. An Oracle 7.3.4 (AIX 4.3.3) database is suffering of some "latch = waits". Especially on "cache buffers lru chain " and some on "modify = parameter values" =20 What can I do about them? I think that the first latch is needed for the server processes in = order to gain access to the LRU list in the buffer cache. Contention there = means that there are a lot of processes that want free buffers. I think it would help if I increase db_block_buffers parameter. am I = right? if not, What about increasing DBWR thoughtput ? What does it mean the second latch? =20 Thanks. ------=_NextPart_000_0747_01C00609.063B5D40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

Forgive my poor = english.

An Oracle 7.3.4 (AIX 4.3.3) = database is=20 suffering of some "latch waits".

Especially on "cache buffers lru chain " and some on = "modify parameter=20 values"

What can I do about them?

I think that the first latch is needed for the server = processes in=20 order to

gain access to the LRU list in the buffer cache. = Contention there=20 means that there

are a lot of processes that want free=20 buffers.

I think it would help if I increase db_block_buffers = parameter. am=20 I right?

= if not, What=20 about increasing DBWR thoughtput ?

What does it mean the second latch? =20

Thanks.