Re: testing memory parameters
From: DA Morgan <damorgan_at_psoug.org>
Date: Sun, 16 Mar 2008 13:46:19 -0700
Message-ID: <1205700378.5819@bubbleator.drizzle.com>
>
> BUFFER CACHE HIT RATIO ia a mythical indicator of performance.
> It should be ignored because it is meaningless.
Date: Sun, 16 Mar 2008 13:46:19 -0700
Message-ID: <1205700378.5819@bubbleator.drizzle.com>
Ana C. Dent wrote:
> "mr..._at_gmail.com" <mrowkin_at_gmail.com> wrote in news:62772aa8-fdbd-42b7-
> a8a0-da91957e30e9_at_e6g2000prf.googlegroups.com:
>
>> I think that I should consider buffer and library cache hit ratios. >> Is this a good way?
>
> BUFFER CACHE HIT RATIO ia a mythical indicator of performance.
> It should be ignored because it is meaningless.
Just to reinforce what Ana wrote ... hit ratios are meaningless nonsense promoted by people who still think they can apply Oracle 7 bad practices to current versions of Oracle.
If you have one of those books that recommends such nonsense do something useful with it. I suggest a recycling bin.
-- 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 Sun Mar 16 2008 - 15:46:19 CDT