Extents.

From: Ganesh Raja <ganesh_at_gtfs-gulf.com>
Date: 24 Nov 2001 23:39:43 -0800
Message-ID: <a8aed4.0111242339.530532a2@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 Sun Nov 25 2001 - 01:39:43 CST