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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Live Reorganize from SQL-script?

Re: Live Reorganize from SQL-script?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 01 May 2005 16:34:42 +0200
Message-ID: <j5q971tiloffmcri769dghmfibd55prnra@4ax.com>


On 1 May 2005 06:41:21 -0700, grz01_at_spray.se wrote:

>Well, even if you dont have fragmentation of extents,
>you may still get e.g. row-migration, from excessive updates,
>tables after deletes will have less dense blocks (requiring more IO
>when read),
>and indexes will usually perform better after rebuilding them, dont
>they?

row migration can be adressed by experimenting with pctused and pctfree.
That indexes will usually perform better after rebuilding them is a myth. That it is a myth has been demonstrated here several times.

--
Sybrand Bakker, Senior Oracle DBA
Received on Sun May 01 2005 - 09:34:42 CDT

Original text of this message

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