Re: Segment Advisor for 10g

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

The ADDM Advisor does not notify you of the need to defrag tables and indexes. This is because in Oracle, it is rare that you need to do so. There is no *utility* to perform the defrag as this can be done with the ALTER TABLE or ALTER INDEX commands.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown