Re: bstat reports negative numbers/statistic definitions

From: Phil Cook <pncook_at_worldnet.att.net>
Date: 1998/03/13
Message-ID: <6ea5bv$9ac@bgtnsc02.worldnet.att.net>#1/1

You have come across an Oracle DBA certification-type question. The counters are exceeding the size of the variables used to track those stats and the numbers are wrapping around.

I don't know of a definitive source for all the stats.

Phil Cook

William Vollenweider <wvollenw_at_mindspring.com> wrote in article <6e9udu$dui_at_camel21.mindspring.com>...
> I am running Oracle 7.3.3 on AIX 4.1 using bstat/estat and getting
negative
> numbers for physical blocks read and written (in the tablespace/datafiles
> section). The collection is run over night (12 hrs) during our batch
> processing. I can't figure out how the negative numbers could reflect
> reality, and ideas?
>
> Also, does anybody know where a description/stats for all of the 7.3.3
> sysstats can be found?
>
>
>
Received on Fri Mar 13 1998 - 00:00:00 CST