space issue 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