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>
> 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
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.orgReceived on Tue Mar 18 2008 - 15:24:23 CDT