Brian Peasland ha scritto:
> Andrea wrote:
>> 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
>>
>
> The keywords are "old version". In older Oracle versions, tablespaces
> were Dictionary Managed. Certain operations would take a long time to
> complete if it dealt with extent allocation or deallocation. In Oracle
> 10g, you should be using Locally Managed Tablespaces. The operations
> that would suffer under DMT's do not suffer under LMT's. Hence there is
> very little reason to "defrag" tables or indexes any more.
i understand, thanks for your explanation
Received on Fri Oct 20 2006 - 14:10:59 CDT
