Re: Extents.

A couple questions first, Oracle Version, OS version????

Is the tablespace locally managed or dictionary managed? Check the minimum extent size on the tablespace itself, this could give the explanation for your question.

HTH,
Pete's

ganesh_at_gtfs-gulf.com (Ganesh Raja) wrote in message news:<a8aed4.0111242339.530532a2_at_posting.google.com>...
> Hi,
>
> I Created a table.
>
> Create Table c( a varchar2(1)) Storage(Initial 20K Next 20K
> PctIncrease 50);
>
> Check Dba_Extents and found that Oracle As Allocated 131072 Bytes for
> the firstextent.
>
> I only requested for 20K Extent Size which is maybe 3 Oracle Blocks.
> Block Size is 8K. But he has allocated 16 Oracle Blocks for me.
>
> And then i checked the Initial_Extent Col of DBA_Segment it says 24576
> which is 24K and acceptable.
>
> But why is this discrepancy in DBA_Extents and DBA_Segments.
>
> And why is oracle allocating more space when i only request for 24K.
>
> All Help is appreciated.
>
> Best Regards,
Received on Mon Nov 26 2001 - 08:00:57 CST