Fragmentation in LMT tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Fragmentation in LMT tablespace

  1. #1
    Join Date
    Nov 2001
    Location
    Singapore
    Posts
    182

    Fragmentation in LMT tablespace

    Everyone says localyy managed tablespace wonot get fragmented since all extents are of uniform size,

    Where as samething dosenot holds good for one of tablespace in my datbase, if i query dba_free_space it returns 23 rows for a perticular.

    could anybody tell me , how LMT works to avoid fragmentation
    J Gangadhar

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    because the extents are reusable by all objects, therefore no big holes which cannot be used

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