Re: testing memory parameters

From: DA Morgan <>
Date: Tue, 18 Mar 2008 13:24:23 -0700
Message-ID: <>

Serge Rielau wrote:
> DA Morgan wrote:

>> Serge Rielau wrote:
>>>> Below what value is BCHR "bad"?
>>> In DB2 I treat any OLTP app with less than 90% hit ratio as troubled.
>>> Anything less than 80% I'd call a mess requiring some serious 
>>> explanation.
>> Because, in DB2, you don't have sufficient instrumentation to look
>> inside and see what is happening.

> Ah, Daniel, you never fail to live up to my expectation of taking a
> cheap shot wherever you can. What would you know about DB2's state of
> perf tuning tools...
> But I digress. I got the answers I needed.
> Thanks Ana
> Serge

Perhaps I was wrong ... please provide me the link to the DB2 equivalent to ASH, AWR, and the wait interface.


Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Tue Mar 18 2008 - 15:24:23 CDT

Original text of this message