Re: Negative V$FILESTAT time values --- How ??

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Mon, 27 Sep 1999 18:02:58 +0100
Message-ID: <938452227.3927.1.nnrp-09.9e984b29@news.demon.co.uk>

There are plenty of bugs and inconsistencies in v$filestat. Exacerbated by things like async I/O, IO slaves, and multiple db writers on the write side particularly.

In the simplest case (though needing a long up time) , you may have managed to roll over the 32-bit counter that records numbers of hundredths of seconds of up time.

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

Kevin A Lewis wrote in message ...
>I have been looking at some very high values on the write side of the
>v$filestat figures and am wondering why?
>
>Particularly why should I be getting negative values in the timing column.
I
>understand if I am using utlbstat and utlestat a shutdown in the middle can
>give this effect, but not this time, I am querying the rows direct.
Received on Mon Sep 27 1999 - 12:02:58 CDT