Re: Segment Advisor for 10g

DA Morgan ha scritto:

> Andrew wrote:
> > Hi,
> >
> > i would like to use ADDM Advisor of oracle 10g for verify defrag problem
> > of oracle object (table,index).
> > But i've read that ADDM "Segment Advisor" answer to shrink the object,
> > not for defrag... is correct?
> >
> > there is some utility for defrag table and index ?
> >
> > thanks for your support
> > bye
> >
> > andrea
>
> If you have 10g then you have Locally Managed Tablespaces too.
>
> Is your desire to defrag based upon some actual metric pointing to a
> real problem or just an indication that you have too much spare time
> on your hands?

nothing of this.. i'm studing for Oracle 10g Certific. OCA :) and i would like to learn this concept.. Received on Fri Oct 20 2006 - 02:55:49 CDT