RE: Latch Contention

From: <Stephen.Lee_at_DTAG.Com>
Date: Mon, 1 Mar 2004 17:09:50 -0600
Message-ID: <D6339830FC73944E889CC3CEADDB205B07909217@bu-dtagpo1.tracs.com>

Possibly lack of bind variables. Without them, the shared pool gets filled up with a bunch of doo-doo, then you get waits while Oracle manages all that doo-doo. If you're just playing around, you could see if reducing the size of the shared pool helps. It gives Oracle less doo-doo to fuss with.

-----Original Message-----

Today we had problems with latch contention in our production Oracle Apps database. I saw lots of latch free waits, of the cache buffer chains and library cache variety. I looked for the most resource intensive sessions. But nothing stood out. Finally I flushed the shared pool (Cary Millsap is going to cringe at this time........). That cleared all the latch free waits and users reported better performance. Didn't want to flush the shared pool but had to do it due to month end close processing that was getting severly bogged down. I still haven't found the root cause. My question is where to look for the root cause next time.
Here are some stats I gathered while the problem occurred.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Mon Mar 01 2004 - 17:06:48 CST