You will need to do this on a regular basis if you don't use LMT's. My
suggestion would be that LMT is suitable for you if your indexes are within
an order of magnitude of each other in size. you don't care if you have 1000
extents though you might if you had 10000.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Mike Borden" <tilwenbr_at_netscape.net> wrote in message
news:8a41a7df.0204290513.2da71f7e_at_posting.google.com...
> Ok, I got it a lot better now. I rebuilt the indexes with the initial
> extent the size of the whole index, and after every rebuild I
> coalesced the tablespace. The coalescing, I know takes up CPU, but
> there wasn't a lot of activity at the time I did it.
>
> I really can't use locally managed tablespace, cause the indexes don't
> all grow at the same rate. This is a vendor supplied schema, so they
> put the names of the indexes and tables into tablespaces that have
> names that relate to those tables and indexes.
>
> Thanks for the help.
Received on Mon Apr 29 2002 - 08:27:20 CDT
