Path: text.usenetserver.com!out04a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!post01.iad01!not-for-mail
Date: Wed, 08 Aug 2007 11:31:12 -0700
From: DA Morgan <damorgan@psoug.org>
Organization: Puget Sound Oracle Users Group
User-Agent: Thunderbird 1.5.0.12 (Windows/20070509)
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: Cache Hit Ratio from system views
References: <1186588653.996873.185140@l70g2000hse.googlegroups.com>
In-Reply-To: <1186588653.996873.185140@l70g2000hse.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Message-ID: <1186597870.627874@bubbleator.drizzle.com>
Cache-Post-Path: bubbleator.drizzle.com!unknown@216.162.218.178
X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/)
Lines: 19
X-Complaints-To: abuse@csolutions.net
Xref: usenetserver.com comp.databases.oracle.server:432659
X-Received-Date: Wed, 08 Aug 2007 14:31:11 EDT (text.usenetserver.com)

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>

Here ...
http://www.oracledba.co.uk/tips/choose.htm
have any hit ratio you want any time you want.

Hit ratio's are meaningless.
-- 
Daniel A. Morgan
University of Washington
damorgan@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org