RE: Question about v$rollstat

Hi Richard:

Firstly, you get the "###"'s because the number is bigger than the format mask used for display.

As for the negative numbers, my guess is that the number has "wrapped" (not a rollback segment wrap!) This also happens with some MTS numbers (in v$shared_server and v$dispatcher.) Because it's stored using a signed, binary number, when it gets too big, the number "goes negative" as it goes back to zero. (I hope you see what I'm talking about here - I'm trying not to go into too much detail to avoid boring people.) I do some fudging with the MTS numbers for my reports, which I can post if needed. Please repost if you have any more questions. HTH.

Colin.

-----Original Message-----
From: Klavers, Richard [mailto:R.Klavers_at_arbeidsbureau.nl] Sent: Friday, June 09, 2000 12:26 AM
To: Multiple recipients of list ORACLE-L Subject: Question about v$rollstat

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
E-mail: r.klavers_at_arbeidsbureau.nl

-- 
Author: Klavers, Richard
  INET: R.Klavers_at_arbeidsbureau.nl

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may