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

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?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org