table size not true with dba

From: Andrea <netsecurity_at_tiscali.it>
Date: 27 Mar 2007 03:48:58 -0700
Message-ID: <1174992538.859531.139510@r56g2000hsd.googlegroups.com>

hi,
i've a oracle 9i db and after run dbms_stats i find a table size with this command:

select bytes,initial_extent,next_extent,extents from dba_segments where segment_name='TRANSIT' and OWNER='SACT';

the ouput is this:

BYTES           INITIAL_EXTENT   NEXT_EXTENT    EXTENTS
----------            --------------
-----------               ----------
 756678656      67502080             377524224          7

so, there is something wrong :-?

if next_extent is about 377Mb and the extents allocated is 7, it should be more then 756Mb (BYTES). Like 67Mb + 377Mb *6 , (initial + 6 extents)
Instead, why i've gather this result?

how i estimate table size?

thanks a lot

andrew Received on Tue Mar 27 2007 - 05:48:58 CDT

table size not true with dba_segments??