DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: space issue

  1. #1
    Join Date
    Jan 2001

    Thumbs up

    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.


  2. #2
    Join Date
    Jul 2000
    Oxford, OH
    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.
    Joe Ramsey
    Senior Database Administrator
    dbaDirect, Inc.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.