Re: Buffer Cache Hit Ration Formulas??

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 13 Aug 1999 20:20:48 +0100
Message-ID: <934572860.3528.0.nnrp-10.9e984b29@news.demon.co.uk>

Thanks for the correction - I hadn't spotted the need for catperf.sql - checked it on 8.0.4 today and it is there.

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

Jurij Modic wrote in message <37b3cf67.5126100_at_news.siol.net>...
>
>Just to add to Jonathan's note: V$BUFFER_POOL_STATISTICS is not
>created at database creation - you have to create it by running
>CATPERF.SQL from your admin directory.
>
>And also a small correction to Jonathan's note: this view is available
>also on 8.0 - at least I have it on my 8.0.5 (and it is mentioned in
>8.0.4 documentation, so I think it should be in 8.0.4 also).
>
>
Received on Fri Aug 13 1999 - 14:20:48 CDT