Re: table fragment and index rebuild time

On Jan 24, 6:39 am, "Steve Robin" <ocma..._at_gmail.com> wrote:
> Hi all,
> I want to know, is there any way to find which tables need to be
> fragmented, and which index need to be rebuild.
> One by one I can find out this by using dbms_space package for tables
> (find unused blocks) and
> analyze index < index_name > validate structure;
> command and then see index_stats and find that.
>
> But I have 5 lacs tables and many indexes, how to know which schema to
> refresh.
> Right now we do that but based according period of work on any schema
> or wait till the performance is get down then we find it and do it.

if you use LMTs fragmentation is a thing of the past. I would rather spend my time on reading the Concept manual.

--
Sybrand Bakker
Senior Oracle DBA