library cache miss ratio very high - how to find out the rot cause
From: Frank Zimmer <frank.zimmer_at_euroscript.lu>
Date: Tue, 22 Apr 2008 10:28:55 +0200
Message-ID: <675lq9F2nkdp0U1@mid.individual.net>
Date: Tue, 22 Apr 2008 10:28:55 +0200
Message-ID: <675lq9F2nkdp0U1@mid.individual.net>
Hi
we are driving a Documentum based ECM system on a big sun machine (12 CPU) (i know that Documentum is creating very bad SQL) Right now sometimes (quite often) the system is totally slow. With some monitoring we can see that at that point the miss ratio for the sql library cache goes over 60 %. At that time the shared SQL area of the SGA is used only by 60 % and the parse to execute ratio is nearly one.
How can i get deeper into that ?
Best regards
Frank
Received on Tue Apr 22 2008 - 03:28:55 CDT