-
I have allocated 2 meg to each partition table(based on months) in my database. I querried the partitions and I have noticed that only 70% of the space alloacted to each partition has been used.
Is the remaining 30% on each partiton freeable? Or since it has not being used by the partitons that means it's still free for other objects to use.
I am thinking that since they have been allocated to the partiton, then that means they "locked up" in the partiton unless they are freed.
Any explanation will be appreciated.
thanks,
Clinton.
-
If the partitions are not subdivided into separate tablespaces then any partition extending should be able to use the space - that's why it's so important to keep extents the same size (initial and next) or at the very least a multiple of each other to avoid fragmentation issues.
When a partition is created it automatically gets at least one initial extent of size initial extent.