library cache miss ratio very high - how to find out the rot cause

From: Frank Zimmer <>
Date: Tue, 22 Apr 2008 10:28:55 +0200
Message-ID: <>


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

Original text of this message