Re: segment size

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Fri, 31 Oct 2003 02:36:06 GMT
Message-ID: <qUjob.7137$ai6.4573@news02.roc.ny>

"richie" <richchri_at_erols.com> wrote in message news:9a436674.0310300618.35831e0b_at_posting.google.com...
> 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.

Are you using LMT's by any chance?.
If yes then what is the extent size/allocation_type on them?

Anurag Received on Thu Oct 30 2003 - 20:36:06 CST