Re: ORACLE Performance Tuning - Your experiences

In article <321030C0.5F0DC7B_at_netcom.com> Steve Harms <sharms_at_netcom.com> writes:

> In a nutshell,
> DFRAG is a space management utility for Oracle databases developed by
> ARIS Corporation. You can use DFRAG to automatically identify and
> rebuild problem objects in your database.
> For more information, look at http://www.ariscorp.com, or
> call ARIS at +1 206.433.2081.

Before you buy expensive tools to defragment your tablespaces and segments you should take a look at Cary V. Millsap's ORACLE white paper at
http://tiburon.us.oracle.com/odp/public/library/cr/html/cr_white.html or http://www.europa.com/cgi-bin/cgiwrap?user=orapub&script=op-abs.pl

There you will find many useful tips how to avoid fragmentation.

Under the same URL you will find a paper by Craig Shallahammer titled Avoiding a Database Reorganisation, it is also quite useful.

Axel Schlueter
Institute of Informatics
University of Hannover, Germany Received on Wed Aug 14 1996 - 00:00:00 CEST