Re: Extents.

empete2000_at_yahoo.com (Pete's) wrote in message news:<6724a51f.0111260600.1c5d6aa1_at_posting.google.com>...
> A couple questions first, Oracle Version, OS version????

Oracle version : 8.1.7.0.0
OS Version Windows Nt 4.0 SP6a.

>
> 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.
>

No It is Dictionary Managed.

The Minimum Extent is 1.

> 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 Tue Nov 27 2001 - 03:07:55 CST