Re: Segment Advisor for 10g

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Fri, 20 Oct 2006 15:41:49 GMT
Message-ID: <J7Fy9w.13E@igsrsparc2.er.usgs.gov>

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.

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

Received on Fri Oct 20 2006 - 10:41:49 CDT