Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> table size not true with dba_segments??
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
![]() |
![]() |