Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Segment Advisor for 10g

Re: Segment Advisor for 10g

From: Andrea <netsecurity_at_tiscali.it>
Date: 20 Oct 2006 07:19:13 -0700
Message-ID: <1161353953.528114.223640@m73g2000cwd.googlegroups.com> 






Brian Peasland wrote:


> 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.




i know that in old version of oracle was needed export, drop and
reimport table for resolve fragmentation
Received on Fri Oct 20 2006 - 09:19:13 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US