Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: bstat/estat v7.3.4

Re: bstat/estat v7.3.4

From: Leonard F Clark <lfc_at_zoom.co.uk>
Date: Sat, 04 Nov 2000 17:07:07 GMT
Message-ID: <3a04421a.3005121@125.0.0.1>

Bruno's right: you get negatives because the database was shut down. The stats are worthless then.

Len

>there are a lot of negative values in the first column (total) for many of
>the results when i run utlbstat.sql followed by utlestat.sql 24 hours later.
>
>i would expect to find positive values since all of the selects use
>(e.value - b.value). the only logical explanation for the values is that
>e.value << b.value, but this does not make sense.
>
>any suggestions?
>
>
>
>
Received on Sat Nov 04 2000 - 11:07:07 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US