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

From: joel garry <>
Date: Tue, 22 Apr 2008 10:24:07 -0700 (PDT)
Message-ID: <>

On Apr 22, 1:28 am, Frank Zimmer <> wrote:
> 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

Just out of curiosity I put the following query into google: documentum oracle queries

I notice a couple of informative links, seems this Robin East fellow knows some things, including SQL profiles and getting sets results.


-- is bogus.
Oracle v. SAP:
Received on Tue Apr 22 2008 - 12:24:07 CDT

Original text of this message