coalescing free space
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: coalescing free space

  1. #1
    Join Date
    Apr 2003
    Posts
    46

    coalescing free space

    hi

    the manuals say if the extent sizes of the tablespace are all uniform , there is no need to coalesce.

    but even if the allocation type is uniform , still there must be some free space which could be left in a tablespace which can be considered for coalesing . if i am not wrong one could require coalescing for uniform managed tablespaces.

    thanks

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434

    Re: coalescing free space

    Originally posted by ser
    hi

    the manuals say if the extent sizes of the tablespace are all uniform , there is no need to coalesce.

    but even if the allocation type is uniform , still there must be some free space which could be left in a tablespace which can be considered for coalesing . if i am not wrong one could require coalescing for uniform managed tablespaces.

    thanks
    I dont think Coalace will do any help for LMT & Uniform Extents.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796

    Re: coalescing free space

    Originally posted by ser
    hi

    the manuals say if the extent sizes of the tablespace are all uniform , there is no need to coalesce.

    but even if the allocation type is uniform , still there must be some free space which could be left in a tablespace which can be considered for coalesing . if i am not wrong one could require coalescing for uniform managed tablespaces.

    thanks
    Coalesce is nothing but combining of free extents into one large big free extent. That would be true for DMT. But in uniform LMT this won't count.

    Even if free space is left so what, extents need not be contiguous, they can be any where, so whats the point of doing a coalesce.

    And more ever do not take coalesce as a physical reorganisation of blocks. In LMT's the space usage information is maintained in BITMAPS
    (1's and 0's where 0's represent free space). Say a table occupying three extents is dropped that means three 1's will be replaced by 3 0's thats all.

    HTH
    Last edited by adewri; 05-31-2003 at 09:09 AM.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

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