Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Rebuild Index recommendations

Re: Rebuild Index recommendations

From: Suresh Bhat <suresh.bhat_at_mitchell-energy.com>
Date: Fri, 22 May 1998 19:15:48 GMT
Message-ID: <01bd85c6$1ec09bc0$a504fa80@mndnet>


The reason to rebuild index is to coalesce the free space into a contiguous disk space. The best way to do this is to set the parameter pctincrease to 1 for the TABLESPACE in question or for that matter all tablespaces except Oracle related tablespaces such as SYSTEM, ROLLBACKS, TOOLS etc.

If you do this, SMON coalesces the free space. Some times it takes upto about 10 minutes to do it but it does it automatically.

suresh.bhat_at_mitchell-energy.com

Sunit Patke <supatke_at_us.ibm.com> wrote in article <355F745E.42A210DF_at_us.ibm.com>...
> Do any of you REBUILD or DROP and CREATE your application indexes? If
> yes what factors do you consider when deciding when to reorg an index
> (and tables for that matter).
>
>
> Thanks
>
> Sunit Patke
>
>
Received on Fri May 22 1998 - 14:15:48 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US