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

Thread: space issue

  1. #1
    Join Date
    Jan 2001
    Posts
    157

    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.

    thanks,
    Clinton.

  2. #2
    Join Date
    Jul 2000
    Location
    Oxford, OH
    Posts
    117
    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.
    (877)687-3227

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