Re: Extents.

From: Bruno Jargot <see_at_reply.to.invalid>
Date: Sun, 25 Nov 2001 09:52:07 +0100
Message-ID: <r5c10u86o5gein5upmetftq8rumb8nehml@4ax.com>

On 24 Nov 2001 23:39:43 -0800, Ganesh Raja wrote:

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

Check the tablespace. It probably has a minimum extent of 128k or it's locally managed. Received on Sun Nov 25 2001 - 02:52:07 CST