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>


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.org
Received on Sun Mar 16 2008 - 15:46:19 CDT

Original text of this message