DEFRAGMENTATION
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: DEFRAGMENTATION

Hybrid View

  1. #1
    Join Date
    Dec 2000
    Posts
    1
    Hello,

    Can anyone tell me if there is a easier way(simple script or command line) to DEFRAG the Tablespaces?

  2. #2
    Join Date
    Aug 2000
    Posts
    52
    alter tablespace <tablespace_name> coalesce;
    This wiil work lf pctincrease is > 0
    sanjay_kansara@hotmail.com

  3. #3
    Join Date
    Dec 2000
    Posts
    15

    Talking Defragmentation

    hi, do u try move tables ?
    If u have some tables in tablespace, try to use extents equal for all tables, if will do it, all tables with only value, wiil be more easy for administration ....

    Sandro Lobo
    sslobo@globo.com
    Sandro Lobo
    Oracle DBA
    www.geocities.com/sslobopt

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    alter tablespace coalesce will always works as long as you issue it manually. If you want Oracle to do it manually set pctincrease > 0 although personally I never set this value to bigger than zero.
    Also when you talk defragmentation what kind are you referring? There are mainly three, Free Space, Extents, Block.

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