Tools for large/fast reorgs

[bzh]

Hello!<br><br>I might have to perform large reorgs soon,<br>so I would like to know if anybody has<br>used (or heard about...) one of the following tools (or some other tools of the kind):<br>- Patrol Db Reorg (from BMC)<br>- ManageIT Ts Reorg (from CA,<br>&nbsp;&nbsp;formerly Platinum Ts Reorg)<br><br>Thanks!<br>

 

[ackelly]

I have used Platinum's tools but have found that Quest's SPACE MANAGER works best for large or frequent re-orgs. Evalutaion copy is available at <A HREF="

http://www.quests.com"

TARGET="_new">

http://www.quests.com</A>.

 

[TimG]

Oracle8i has the ALTER TABLE ... MOVE command, which runs in PARALLEL with NOLOGGING.&nbsp;&nbsp;Can't beat it, and it comes with the database.&nbsp;&nbsp;However, if you're not on 8i, then this doesn't help.<br><br>Buying a reorg product perpetuates the original problem.&nbsp;&nbsp;The solution to tablespace fragmentation is uniform-sized extents within a tablespace, not a reorg product.&nbsp;&nbsp;Also, most folks reorg when they don't need to, based on the myth that &quot;everything should be in a single extent&quot;.&nbsp;&nbsp;Multiple extents up to several hundred is clearly not an issue, as long as they are sized uniformly thus not creating a &quot;bubble-fragmentation&quot; problem within the tablespace.&nbsp;&nbsp;The ideal reorg product would be one that is used once (to fix the problem) and then never again, but I'm sure none of them are designed for that...&nbsp;&nbsp;