Running oracle 9 and 8i on linux platform (redhat 8). Just a general
oracle question. A segment is made up of extents. In our case the
initial and next extent size is 1M. One of our segments for example
has lets say 800 extents (From the "extents" field from dba_segments
or user_segments for that user). So if segments are made up of extents
and we have 800 of them at 1M each. Shouldn't the size of the segment
(the sum of the "Bytes" field for that segment_name from the
dba_segments table) total 800 Mbs? I get a almost 300Mb? Where's the
other 500Mbs of space? Does that mean this is lost in fragmented
space? So if I rearrange things and everything gets packed nicely with
no gaps do I get back
the missing 500MBs? Or do these values mean something else that I'm
not aware of?
thanks.
Received on Thu Oct 30 2003 - 08:18:27 CST
