Re: run time stats and x$ tables

Why bother with this reply of "there are better ways!" It is meaningless (sic) especially when you give no clue as to what the "better ways" might be.

In article <381E9F62.DDF31DA8_at_gelrevision.nl>,   "akolk - gelrevision.nl" <akolk_at_gelrevision.nl> wrote:
> Why bother with this hitratio, it is meaning less especially when you
> calculate it over an week !
> There are better ways !
>
> Anjo.
>
> Ed Stevens wrote:
>
> > I have begun tracking performance statistics on my Oracle databases.
> > Right now I am focusing on cache miss ratio, using the following
query:
> >
> > select
> > p.bp_name buffer_pool,
> > lpad(to_char(100 * sum(s.pread) / sum(s.dbbget + s.conget),
'990.00')
> > || '%', 13) miss_rate
> > from
> > sys.x_$kcbwds s,
> > sys.x_$kcbwbpd p
> > where
> > s.set_id >= p.bp_lo_sid and
> > s.set_id <= p.bp_hi_sid and
> > p.bp_size != 0
> > group by
> > p.bp_name
> > /
> >
> > (X_$kcbwds and x_$kcbwbpd are views that map directly to the tables
> > X$kcbwds and x$kcbwbpd).
> >
> > My basic question is - when are numbers in these ?statistics
gathering?
> > tables updated, and when are they zeroed? At its roots, the above
> > query is selecting PREAD, DBBGET, and CONGET from x$kcbwds, and
> > bp_name from x$kcbwbpd. But I don?t really know for what time
frame
> > these numbers are derived. If I run this query every day for a
week,
> > and the database is never shut down, do Tuesday?s numbers also
include
> > Monday?s numbers?
> >
> > - Ed Stevens
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>

--
Ed Stevens
(Opinions are not necessarily those of my employer)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Nov 02 1999 - 07:41:24 CST