Re: Rebuilding Indexes

From: Oracleguru, Suresh Bhat <oracleguru_at_mailcity.com>
Date: Thu, 04 Feb 1999 15:51:54 GMT
Message-ID: <01be5066$5b2fd420$a504fa80@mndnet>

Hi !

I would also do the following for all tablspaces ( not the tables ) except Oracle created tablespaces such as SYSTEM, RBS, TOOLS etc.

alter tablespace tablespace_name default storage ( pctincrease 1 );

What this does is sets the pctincrease for tablespaces to other than 0, in which case the Oracle background process SMON, COALESCEs the contiguous free space autoamtically every time it wakes up which is about every couple of minutes or so.

oracleguru
www.oracleguru.net
oraclguru_at_mailcity.com

Jeanne <jcman_at_SPAMMEBABY.worldnet.att.net> wrote in article <79aq50$nnv_at_bgtnsc02.worldnet.att.net>...
> We are doing an application upgrade that requires dropping and
> re-creating every application index in the database. After dropping all
> indexes for a tablespace (which only contained indexes), is there any
other
> maintenance needed in the tablespace? Would there be anything to gain my
> dropping and recreating the tablespace, or is it pretty much initialized
at
> that point?
> Thanks so much for any replies!
>
>
>
Received on Thu Feb 04 1999 - 09:51:54 CST