v$Rollstat numbers

From: Ravi Kulkarni <nandagokul_at_yahoo.com>
Date: Thu, 16 Oct 2003 14:39:25 -0800
Message-ID: <F001.005D369B.20031016143925@fatcity.com>

We have a 8.1.7.0 with the following from v$rollstat. Extent size is 10M for all segments. Do you find anything unusual with usn#3? I expect Rssize for to be 17G (1777*10M - extents*extent_size).

       USN EXTENTS RSSIZE

---------- ---------- ----------------
         0         11          770,048
         1        244    2,558,509,056
         2         26      272,613,376
         3       1776    1,558,151,168
         4        224    2,348,793,856
         5        195    2,044,706,816
         6        184    1,929,363,456
         7        260    2,726,281,216
         8         13      136,298,496

(FYI-We are not using optimal - hence the bloated
rssize's)

TIA,
Ravi.

---

Do you Yahoo!?
The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ravi Kulkarni
  INET: nandagokul_at_yahoo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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

also send the HELP command for other information (like subscribing).

Received on Thu Oct 16 2003 - 17:39:25 CDT