RE: Some Latch Questions

Thank you Elliott.

-----Mensaje original-----
De: Elliott, Patrick <Patrick.Elliott_at_bestbuy.com> Para: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Fecha: Lunes 14 de Agosto de 2000 7:36 PM Asunto: RE: Some Latch Questions

>Here is what I found in MetaLink:
>
>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.
>
>
>Hi. Actually, this latch is not acquired based on an alter session command,
>we get this latch during user session initialization. We need to get the
>latch at this time because we are copying the parameter values which are
>stored in the SGA to private memory.
>
>However, as stated by Bumby, this has usually occurred as a side effect of
>other contention which was resolved after tuning to resolve that issue.
>Regards,
>Helen Schoone
>Oracle Server EE Analyst
>
>
>> -----Original Message-----
>> From: Diego Cutrone [SMTP:dcutrone_at_afip.gov.ar]
>> Sent: Monday, August 14, 2000 3:13 PM
>> To: Multiple recipients of list ORACLE-L
>> Subject: Some Latch Questions
>>
>> 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"
>>
>> 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?
>>
>> Thanks.
>--
>Author: Elliott, Patrick
> INET: Patrick.Elliott_at_bestbuy.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Received on Wed Aug 16 2000 - 14:37:42 CDT