Re: bstat reports negative numbers/statistic definitions

From: Julio <julio.negueruela_at_si.unirioja.es>
Date: 1998/03/13
Message-ID: <35098C74.7E7C@si.unirioja.es>#1/1

William Vollenweider wrote:
>

> I am running Oracle 7.3.3 on AIX 4.1 using bstat/estat and getting nega
tive
> numbers for physical blocks read and written (in the tablespace/datafil
es
> 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?

May be yoy've had an overflow in the vars where statistics are kept. Try to stop statistics save then in a file and restart them( but saving in another location) six hours after the begining.

-- 

Julio Negueruela
DBA    Servicio Inform tico
Universidad de La Rioja      -      Spain
Telf: 941-299179     Fax: 941- 299180
mailto:julio.negueruela_at_si.unirioja.es

Received on Fri Mar 13 1998 - 00:00:00 CST