Re: Cache Hit Ratio from system views

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_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org