I am confused and needing some clarification on space utilization with a table. Please forgive me if the question is a simple answer, I am drawing a blank on explaining it.
I have performed a datapump export from Enterprise Edition and imported into XE. I have a number of tables with this issue, but I am unsure about how to explain it.
The table has 567 rows with the average row length of 85. It shows 42 Blocks on what I believe is a 16K block database (I didn't modify the default for the Windows 11gXE).
The table initial extent was set to 300. I presume that was a problem with how it was originally created and datapump just replicated it's orginal sizing, but next extent is set to 1Mb. The table indicates 10 Extents and a total size of 304Mb.
Question 1: If the data is only (42 blocks * 16K =) 672K then why would the system have an additional 9 extents added when initial table size was 300Mb?
Question 2: If the initial size was 300 Mb and 9 additional extents are created why is the table size 304Mb instead of (300 + 1Mb * 9 extents=) 309Mb?
Question 3: Is there an easy way to resize a table that is setup like this, and if so how do we do it? I'd like to get usage and growth rate statistics from the user and set it for 1 year with next extents representing 3 month growth rates.
Thank you in advance,
Adam