Path: text.usenetserver.com!out02a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!q75g2000hsh.googlegroups.com!not-for-mail
From:  Teresa Masino <teresa.masino@peninsula.org>
Newsgroups: comp.databases.oracle.server
Subject: Re: Cache Hit Ratio from system views
Date: Wed, 08 Aug 2007 12:02:46 -0700
Organization: http://groups.google.com
Lines: 33
Message-ID: <1186599766.578604.210630@q75g2000hsh.googlegroups.com>
References: <1186588653.996873.185140@l70g2000hse.googlegroups.com>
   <1186597870.627874@bubbleator.drizzle.com>
NNTP-Posting-Host: 168.67.1.19
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-Trace: posting.google.com 1186599767 18992 127.0.0.1 (8 Aug 2007 19:02:47 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 8 Aug 2007 19:02:47 +0000 (UTC)
In-Reply-To: <1186597870.627874@bubbleator.drizzle.com>
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: q75g2000hsh.googlegroups.com; posting-host=168.67.1.19;
   posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0
Xref: usenetserver.com comp.databases.oracle.server:432668
X-Received-Date: Wed, 08 Aug 2007 15:02:48 EDT (text.usenetserver.com)

On Aug 8, 2:31 pm, DA Morgan <damor...@psoug.org> wrote:
> Teresa Masino wrote:
> > We have acquired a software package that sends alerts based on defined
> > thresholds and/or events.  We are working on a simple alert like when
> > the cache hit ratio falls below a given threshold.
>
> Because you wanted to hurt yourself and there weren't any brick in the
> office you could drop on your toes? <g>

:-)  yea, basically

> Here ...http://www.oracledba.co.uk/tips/choose.htm
> have any hit ratio you want any time you want.
>
> Hit ratio's are meaningless.

Alone, yea, but they can sometimes be an indicator that an instance
needs attention.  I wouldn't change anything based on just this, but
it would tell us to maybe take a closer look and run AWR or
statspack.  For us, this was supposed to be an easy thing to test
setting up alerts -- at least we thought it was.  Then this boondoggle
began.  Then I got curious, which is just another way of saying I
started looking for a brick.  :-)

Thanks
Teresa

> Daniel A. Morgan
> University of Washington
> damor...@x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org