Re: segment size

From: mcstock <mcstock_at_enquery.com>
Date: Thu, 30 Oct 2003 10:00:10 -0500
Message-ID: <Y5mdnWSfy9gDujyiRVn-sA@comcast.com>

check the individual extent sizes in DBA_EXTENTS or USER_EXTENTS

the next and initial extent settings are the current settings, not what existed over the life of the segment -- especially if PCT_INCREASE is non-zero

"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.
Received on Thu Oct 30 2003 - 09:00:10 CST