Re: Defragmenting Oracle files on Win2k

Chuck <chuckh_at_softhome.net> wrote in message news:<Xns932171EDF67AAchuckhsofthomenet_at_130.133.1.4>...
> 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".

Don't use "autoextend on" for datafiles. create datafiles of size say 512M, 1024M. never delete them, just reuse them if you drop that tablespace. don't allow *any* other files to be created on any filesystem that contains oracle datafiles, including archived logs. datafiles only. and don't use autoextend for datafiles. just add datafiles to tablespaces when needed.
keep 50% free space on every volume. that way, you know you have room for a trial recovery or 2. and NTFS will behave as you want it to that way.
and you won't need to defragment.

Paul Received on Fri Feb 14 2003 - 00:50:41 CST