Fragmentation and defragmentation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Fragmentation and defragmentation

  1. #1
    Join Date
    May 2002
    Posts
    6
    how to check fragmentation of a table/tablespace and how to defragment it.? Are there any procedures to do this.what are the views to check out?
    bharathsu

  2. #2
    Join Date
    Jul 2000
    Location
    Amsterdam
    Posts
    234

    Fragmentation

    Hi,

    You can do a

    select tablespace_name, bytes/1024/1024 from dba_free_space order by tablespace_name;

    To defrag move/ rebuild all your objects to an other tablespace and coalesce and move / rebuild back to your initial tablespace.

    Tycho


  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    When you rebuild,
    Make sure you use initial extent, next extent sizes are equal and pctincrease set to zero. Alternatively you can use LMTs to avoid fragmentation.
    Reddy,Sam

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