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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
