Re: any better way to quesy DBA_INDEXES, DBA_IND_COLUMNS...?

I agree with you, Paul. But there are a lot of small pieces of free space that I cannot use it for larger extents.

and I'm out of larger free space for some indexes to extent. That why I try to reorganize the whole tablespace. :)

Phil

"Paul Drake" <paled_at_home.com> wrote in message news:3B6DCE1D.22AFE3E2_at_home.com...
> "phil_at_pacbell.net" wrote:
>
> > Hi,
> >
> > I'm currently writting a program that would generate a SQL script to
> > reorganize a whole index tablespace.
> > I try to get the indormation from DBA_INDEXES, DBA_IND_COLUMNS,
> > DBA_TAB_COLUMNS, DBA_SEGMENTS.
> >
> > Following are my SQL statements, and they took a while to retrieve the
> > information. Please let me know if you have better idea. Also, if you
 like
> > this utility, please email me at "phil_sheu_at_amax.com" . I'll email you a
> > copy when I finished.
 

> > 4. Try to get the allocated space for every index, to compress all
 extents
>
> Hi.
>
> If you're using LMTs with uniform extent sizing, do you really want to
 bother
> with this part?
> I can see a slight benefit from having the extents in a contiguous area of
 the
> disk(s), but otherwise, the single extent paradigm has largely been
 debunked.
>
> just my opinion.
>
> Paul
>
>
>
Received on Tue Aug 07 2001 - 09:42:28 CDT