Re: 'Coalesce' indexes tablespace pre-7.3

Try setting pctincrease for index tablespace to 1. SMON will take care of COALESCING whenever it wakes up, which is very often.

suresh.bhat_at_mitchell-energy.com

GT Jeff Cherer <gcherer_at_kraft.com> wrote in article <hBo81.1482$wM5.2884535_at_news.giganews.com>...
> new (to oracle - actually have been on the planet for quite some time)
geek
> here.
>
> running 7.1 and have a tablespace that is pure indexes.
> it is running low on freespace and is honeycombed.
>
> well, ya can't export/import a ts; and i can't export/import index
objects
> (without going thru trickery and deceipt, you know what i mean). so, i
drop
> all the indexes (except a couple of pk's that i need up), and recreate
them.
> very minimal effect on the problem.
>
> adding space will put off the freespace problem, but it won't do much for
> the honeycomb problem.
>
> surely, someone has dealt with this situation. please, some advice.
>
>
>
Received on Wed May 20 1998 - 09:06:03 CDT