Question about v$rollstat

From: Klavers, Richard <R.Klavers_at_arbeidsbureau.nl>
Date: Fri, 9 Jun 2000 08:10:29 +0200
Message-Id: <10522.108343@fatcity.com>

Hi,

when I query v$rollstat I get this output:

08:03:55 SQL> select usn, writes from v$rollstat;

USN WRITES
------------ ------------

           0        2,922
           2 ############
           3 ############
           4 ############
           5 ############
           6 ############
           7 ############
           8 ############
           9 ############

9 rows selected.

08:04:07 SQL> col writes format 999,999,999,999; 08:04:21 SQL> / USN WRITES
------------ ----------------

           0            2,922
           2   -1,481,131,928
           3   -1,517,140,301
           4   -1,330,260,023
           5   -1,307,005,275
           6   -1,294,039,662
           7   -1,417,634,775
           8   -1,273,804,559
           9   -1,379,486,393

9 rows selected.

08:04:21 SQL> Can someone please explain why there is at first the symbol #, and after formatting the column there is a negative value? Musn't this always be positive? How can there be a negative number of writes? Is this caused by a large delete? Now we are performing updates again, and the values are decreasing instead of (normally) increasing. I am confused here, what am I missing?

TIA. Regards, Richard Klavers

Tel.: 00 31 (0)79 371 2543
Fax: 00 31 (0)79 371 2529 Received on Fri Jun 09 2000 - 01:10:29 CDT