Re: Defragmenting Oracle files on Win2k

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Thu, 13 Feb 2003 08:43:27 -0800
Message-ID: <3E4BCB2F.5C2A2207@exesolutions.com>

Chuck wrote:

> Has anyone had any experience using the Win2k disk defragmenter on Oracle
> datafiles? Did you see any performance gains by defragmenting the Oracle's
> datafiles at the O/S level? Do you think it would be worth the time spent
> defragmenting 30g worth of datafiles?
>
> Metalink offers little information on the topic other than the standard CYA
> of "shut it down and back it up first".

Never seen an improvement nor would I expect to. Oracle datafiles are almost always, and as far as I am concerned should always, be fixed in size.

Unless you are laying them down on a hard disk that looks like Swiss cheese. There should be nothing to defrag.

Daniel Morgan Received on Thu Feb 13 2003 - 10:43:27 CST