Re: latch contention

From: Kenneth Koenraadt <plovmand_at_hotmail.com>
Date: Tue, 06 Nov 2001 16:04:49 GMT
Message-ID: <3be80739.6047638@news.mobilixnet.dk>

On 6 Nov 2001 15:06:43 GMT, Ed Lufker <elufker_at_shimi.swcp.com> wrote:

>Hi All:
>
>
>Does increasing the shared_pool and buffer_cache help relieve latch
>contention????
>
>
>Thanks
>eddie lufker

No. Increasing buffer cache size and/or shared pool size may solve many other performance issues, but not latch contention. In fact, a large buffer cache in a heavy loaded system might even introduce latch contention.

Latch contention is a quite rare problem, are you really sure that is what troubles your system ?

Regards,
Kenneth Koenraadt
Systems Consultant
Oracle Certified Professional - DBA
plovmand@<no-spam>hotmail.com Received on Tue Nov 06 2001 - 10:04:49 CST