Re: testing memory parameters

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 18 Mar 2008 13:24:23 -0700
Message-ID: <1205871862.540237@bubbleator.drizzle.com>


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.

Thanks.

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

Original text of this message