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

Thread: Fragmentation

  1. #1
    Join Date
    Oct 2001
    Posts
    23
    Dear friends,

    Could anybody explain me how is the best way (in the storage clause) to create a table/tablespace to minimize fragmentation ? I didn´t understand it yet.

    Hugs,

    Rômulo.


  2. #2
    Join Date
    Aug 2001
    Location
    Waterloo, On
    Posts
    547
    You would want your table to fit into one large extent.
    However, table size may be unpredictable and if you are using locally managed tablespaces (Oracle 8i and above), you need not worry much about fragmentation.

    Raminder Singh

    Oracle Certified DBA: Oracle 8i, 9i


    Mail me at raminderahluwalia@rediffmail.com.

  3. #3
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    Use the MINIMUM EXTENT clause while creating the tablespace so that any extent deallocated can be used effectively, thus reducing the wastage of space.

  4. #4
    Join Date
    Apr 2001
    Posts
    219
    ______________________
    Applications come and go,
    but the data remains!

  5. #5
    Join Date
    Feb 2001
    Posts
    389
    If u r using Oracle8i, Locally managed tablespaces can help.ANd better knowing your data will
    certainly.

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    what I do is

    in Oracle 8

    create several tablespaces, probbaly 5, each tablespace suits for each size of segments

    micro
    small
    medium
    big
    maco

    use minimum extent clause always, number of extents doesnt really affect perfomance in reading but when allocating it will, dictionary tables would have migrated, chained rows and high ST enqueue contention

    in Oracle 8i use
    LMT with uniform size extents, create several as above although number of extents doesnt affect perfomance in LMT

  7. #7
    Join Date
    Oct 2001
    Posts
    23

    Thumbs up Thanks



    Thanks for every answers.

    Hugs.

    Rômulo

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